Microsoft Excel cannot access file

[justhumm]

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!

 

[SkipVought]

The Addins folder might be in a different location.

Do a File Search for addin and go from there.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[Agent666]

Try load the xlam file through the options addin route from say your desktop, does the same thing occur? It could be for some reason your profile doesn't have the correct permissions to that directory.

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/ar...l-starts-6509b9af-2cc8-4fb6-9ef5-cf5f1d292c19

 

[justhumm]

@Agent666, I tried loading it from three different folders...Desktop, \root\...\XLStart, \users\...\XLStart.

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.

 

[Agent666]

On your old computer can you set it to not be a addin (from the VBE, there is an option if you select the ThisWorkbook module (think it's 'isaddin' or similar from memory), save it as a normal macro enabled workbook). Then transfer it to the new computer, open it and save it as an addin.

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).

 

[Agent666]

Disable any COM Addins as these can mess with normal Excel Addins. For example the bluebeam addin causes some of my own Addins not to work as intended.

 

[justhumm]

I thought I tried this the other day, but apparently I didn't or I did it "wrong"...

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!