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!
Talk To Other Members
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!