question

GilbertNoetzel-2373 avatar image
0 Votes"
GilbertNoetzel-2373 asked emilyhua-msft commented

Microsoft Excel 2019 cannot access the file ATPVBAEN.XLAM

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




office-excel-itpro
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


Did you check if the file is valid? (For example, copy and rename it to ATPVBAEN.zip and try opening as an archive).


1 Vote 1 ·

1 Answer

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered emilyhua-msft commented

Hi @GilbertNoetzel-2373

Can this sheet opened correctly on other computers with Office 2019 installed?
It's recommended to create a new workbook that uses Data Analysis Tool on this user's machine, and open it to have a check.

Then I suggest you tried to perform an Online Repair for Office 2019 from Control Panel.

Please make sure VBA is not disabled.
You can go to File > Options > Trust Center > Trust Center Settings > Macro Settings, check whther macro is enabled.

If there is any 3rd-party COM add-in, please go to File > Options > Add-ins > Manage, COM add-ins > Go, temporarily disabled it to avoid any conflict.


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @GilbertNoetzel-2373
If you have a chance to be back, welcome to share us with the updates or any further issues.

0 Votes 0 ·