Recent Posts

61

Technical Support / Re: I just lost 34 days of data. Anybody know how to restore from Onedrive???

« Last post by Scott on May 13, 2024, 04:28:59 pm »

Im not sure what I did but I accidentally replied directly in your message (some kind of admin thing...).
I removed it and will paste down here:

The Chart Title sounds like you hit the F11 key; in excel that key will make a new worksheet with a blank chart if you hit it with no data selected.  If you dont see the worksheet tabs because you are in the Full Screen mode, you can hit CTRL+Page UP and CTRL+Page Down to cycle through the worksheets.  Cycle to a sheet that has the full screen button at the top right, click it, and it will show the tab names, and you can right click and delete the new tab that was created in error.

62

Technical Support / Any OneDrive and Excel experts out there?

« Last post by Suavepenguin on May 13, 2024, 12:21:02 pm »

I need help ASAP with both Excel and OneDrive. Apparently my Excel was NOT Autosaving the MyCostPro worksheets since 4/10/2024, even though it was set to do so. It looks like the local file was corrupted, and I lost all data since 4/10/2024. So, if I try to open MyCostPro from the icon on my desktop, it just does crazy stuff and locks up. I have to open Excel via the "All Apps" tab in Windows, and pick the MyCostPro worksheet saved on OneDrive, which is mostly up to date again. I need to figure out what happened and make sure my data is being saved, I can't go through this again. I'm willing to pay for your time.

63

Technical Support / Re: I just lost 34 days of data. Anybody know how to restore from Onedrive???

« Last post by Suavepenguin on May 13, 2024, 08:20:36 am »

At this point, I can only open MyCostPro worksheet by starting Excel through Applications in Windows, then opening the version of MyCostPro stored on Onedrive. In otherwords, trying to open the worksheet from the Desktop icon gives me this error. I really can't have this happening, Scott can you help me out here? Thanks! I have rebuilt MOST of the file data, another hour it should be mostly there (lost 34 days worth of Inventory source/purchase dates, and I have 34 days worth of sold inventory still in my product master, and all Mileage and Expense records for the last 34 days are gone).

64

Technical Support / Re: I just lost 34 days of data. Anybody know how to restore from Onedrive???

« Last post by Suavepenguin on May 13, 2024, 07:44:58 am »

And now, after manually restoring as much as possible, I open it up again, but I get a big screen that says "Chart Title", a bunch of colored boxes, and a message box saying "Microsoft Visual Basic" "Run-time error '1004':

Unable to set the DisplayHeadings propert of the Window Class

I need some help here.

65

Technical Support / I just lost 34 days of data. Anybody know how to restore from Onedrive???

« Last post by Suavepenguin on May 13, 2024, 06:23:43 am »

My copy of MyCostPro freaked out this morning, I must have bumped something, it got stuck in some weird spot, I was able to get it going with data from 4/10/2024, I don't see more current versions in OneDrive. I do auto saves, I should see more recent versions. I am potentially screwed here, I don't have paper docs to rebuild this....

66

Technical Support / Re: Call Duration - Why only 90 days when ebay now allows up to 2 years

« Last post by Scott on May 01, 2024, 09:15:12 pm »

Hi,
This is a complicated question to answer, but thank you for the opportunity to address this.
Ebay offers many different APIs for developers to access, each of which allow very specific information to be returned.

Currently only the eBay 'Fulfillment' API allows a query duration of greater than 90 days. 
However, MyCostPro gathers most of the data critical to seller-bookeeping from various other APIs that currently do not allow a query duration of greater than 90 days.

Going forward, we are continuously following the progress that eBay makes on API updates and will continue to add additional functionality to MyCostPro as it is made available through the eBay APIs.

Thanks again for the great question.
Scott

67

Technical Support / Call Duration - Why only 90 days when ebay now allows up to 2 years

« Last post by ChetK on May 01, 2024, 10:03:18 am »

I am looking to start a new spreadsheet for 2024. Ebay now allows recall of up to 2 years of sales (in past I know was 90 days), I input 150 days in the "call duration" box and reset, but only got the last 90 days downloaded onto the new spreadsheet. Is the 90 days a spreadsheet limitation, or is ebay only allowing 90 days of downloading, while you can view 2 years on ebay? If possible can you adjust to two years of call duration? This may be a sales opportunity for you, for people that need your spreadsheet, they can get their full current year of sales, and all of last years sales as well.

Please advise, thank you.

68

Technical Support / Re: After "Back End" upgrades, I can't auto update or sync with One Drive

« Last post by Suavepenguin on April 10, 2024, 09:39:33 pm »

Thanks Scott, I suspected as much, but just wanted to bounce it off you, since the timing was odd. I'll keep working on it.

69

Technical Support / Re: After "Back End" upgrades, I can't auto update or sync with One Drive

« Last post by Scott on April 10, 2024, 04:42:14 pm »

Suavepenguin,
The recent back end update timing would just be a coincidence, it didnt change anything that would affect the excel file.
Im not sure of the solution as this seems to be a widespread issue with one drive... here is a link to the Microsoft forum with some discussions and possible solutions on the topic:  https://answers.microsoft.com/en-us/msoffice/forum/all/xlsm-files-not-auto-saving-to-onedrive/bbfdfd44-6866-4bbd-86f8-d2f2d764643c

70

Technical Support / Re: After "Back End" upgrades, I can't auto update or sync with One Drive

« Last post by Suavepenguin on April 10, 2024, 06:53:15 am »

Scott, just an update. I completely unlinked my PC from One Drive overnight. When relinked, all files OK EXCEPT for the MyCostPro. This is concerning, as I have no offsite file backup.