Forum Discussion
311battey
Feb 09, 2020Copper Contributor
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??
311battey
Feb 17, 2020Copper Contributor
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.
JKPieterse
Feb 18, 2020Silver Contributor
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.