×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Microsoft Excel cannot access file

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!

RE: Microsoft Excel cannot access file

The Addins folder might be in a different location.

Do a File Search for addin and go from there.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Microsoft Excel cannot access file

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/article/customize...

RE: Microsoft Excel cannot access file

(OP)
@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.


RE: Microsoft Excel cannot access file

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

RE: Microsoft Excel cannot access file

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.

RE: Microsoft Excel cannot access file

(OP)
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!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login



News


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close