Forum Discussion
Recovery of personal.xlsb lost on Excel update.
10 days ago I changed from Office 2016 to O365. Is there anyway to recover my former personal.xlsb file that was lost in this process??
If your Office appears to work as expected I see no reason to reinstall it.
OK. I found an old personal.xlsb file from my image backups and replaced a newly created personal.xlsb file in the XLSTART folder with the old file.
Now when Excel starts it generates the following error message:
Clicking on the Help button gives the following:
So 2 questions:
Why do my VBA Declare statements have to be changed now when they worked before and more importantly, what's with the error message when I try to use the help button? This is a single user PC and I have full administrator rights.
Thanks.
- Apparently you installed 64 bit Office and your declare statements lack the PtrSafe keyword, see: https://jkp-ads.com/articles/apideclarations.asp . About Help not working: I presume there is a problem with your Office setup, perhaps a repair fixes this.