We are deploying MS Office 2019.
Among a user - this user is unable to open an Excel sheet that utilized Analysis Toolpak - VBA Add-ins. Once the sheet is open the following error appears:
Microsoft Excel cannot access the file c:\xxxxxxxx\ATPVBAEN.XLAM. There are several possible reasons:
1 - the file name or path does not exist
2 - the file is being used by another program
3 - the workbook you are trying to save has the same name as a currently open workbook
All the bullets above are not true as follows:
Bullet 1 - the file is there (C:\Program Files\Microsoft Office\root\Office16\Library\Analysis\ATPVBAEN.XLAM
Bullet 2 - There are no other program using the file
Bullet 3 - There are no other workbook open or used
I do not want to regress the user from Excel 2019 to Excel 2010 where we KNOW it works under 2010.
Anyone has a solution?
Thanks,
Gil