Microsoft Excel cannot access file
Microsoft Excel cannot access file
(OP)
On my old computer (1-2 years old), I had been running an XLAM add-in (some version of Office 365 on Windows 10). And it was working fine.
This week, I got a new computer running Excel version 1906 (Office 365) on Windows 10. And when I try to load the XLAM add-in, I get a messaged stating, "Microsoft Excel cnanot access the file 'C:\Users\xxx\AppData\Roming\Microsoft\AddIns\xxx.xlam'. There are several possible reasons..."
Excel seems to be working normally, otherwise.
I did an internet search and read several posts noting similar issues, but found nothing that fixes this for me.
Any ideas what would be causing this error? Thanks!
This week, I got a new computer running Excel version 1906 (Office 365) on Windows 10. And when I try to load the XLAM add-in, I get a messaged stating, "Microsoft Excel cnanot access the file 'C:\Users\xxx\AppData\Roming\Microsoft\AddIns\xxx.xlam'. There are several possible reasons..."
Excel seems to be working normally, otherwise.
I did an internet search and read several posts noting similar issues, but found nothing that fixes this for me.
Any ideas what would be causing this error? Thanks!

RE: Microsoft Excel cannot access file
Do a File Search for addin and go from there.
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Microsoft Excel cannot access file
I believe you can also copy it into the xlstart folder and it will load any Addins with Excel.
https://support.office.com/en-us/article/customize...
RE: Microsoft Excel cannot access file
All three folders are in the trusted locations list.
I got the same error message each time.
And for the two XLStart folders, it did not auto-load.
Also tried loading excel in safe mode. Got the same message when I tried to load the add-in.
No dice.
RE: Microsoft Excel cannot access file
Just a thought as well, you might need to change some of the macro security on the new machine & enable programmatic access to excel VBE (depending on what's in your addin).
RE: Microsoft Excel cannot access file
RE: Microsoft Excel cannot access file
I had originally written the code for the add-in with a XLM.
I just (again?) opened the XLM file and saved it as an XLAM file...and the add-in loaded and worked fine.
Thanks for the replies!