Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations KootK on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Microsoft Excel cannot access file

Status
Not open for further replies.
justhumm

justhumm

Structural
May 2, 2003
112
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!

capture01_giyusm.png
 
Replies continue below

Recommended for you

Sort by date Sort by votes
The Addins folder might be in a different location.

Do a File Search for addin and go from there.

Skip,

[glasses]Just traded in my OLD subtlety...
for a NUance![tongue]
 
Upvote 0 Downvote
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.

 
Upvote 0 Downvote
@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.


 
Upvote 0 Downvote
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).
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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!

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

vinodnx7
  • Locked
  • Question
Micro to compare two excel file for mirror change
Replies
4
Views
865
vinodnx7
vinodnx7
BhagyeshVashi
  • Locked
  • Question
Need a rename macro for excel
Replies
11
Views
1K
sdz
sdz
Kenja824
  • Locked
  • Question
excel Formula Find help
Replies
5
Views
1K
Kenja824
Kenja824
jhn1611
  • Locked
  • Question
Compass question excel 4
2 3 4
Replies
62
Views
2K
IDS
IDS
3DDave
  • Locked
  • Question
Python now integrated into Excel - apparently
Replies
8
Views
1K
IDS
IDS

Part and Inventory Search

Sponsor

Back
Top Bottom