What steps are needed to eliminate an add-in in Excel?
What steps are needed to eliminate an add-in in Excel?
Hello
I moved my Excel software from a Windows 7 PC to a Windows 11 PC. After two weeks everything is fine. All my VBA was working and the add-in (structuralVBA.xlam) was functioning properly. Then I imported a workbook from my archive, which referenced the same add-in but at a different location. Since the add-in was moved, Excel tried to open two versions with the same name. I deleted the archived add-in, broke the links and redirected everything to the correct one. Fixed. Nope.
Every time I attempt to run a macro, I receive a warning, part of which tells me the add-in was deleted but still allows me to proceed. I renamed the add-in and then removed the old links. Still no success.
How can I resolve this issue? I’m unable to use Excel and am now working on my Windows 7 PC again.
I’m considering deleting all Excel files, removing the software entirely and starting over, but I suspect that won’t fix the problem. I bet the registry is involved.
Regards Dan
EDIT
: I followed Microsoft advice and deleted the Cache and still no success. Has started to tell me that I cannot open two workbooks of the same name?
I receive a warning that tells me the add-in has been deleted but still lets me proceed further.
Do you have the ability to open and modify the .xlam file?
How much progress can you achieve initially, and what happens when it continues to advance?
Can you walk through the macro step by step to see each action’s outcome?
What are the complete file paths for each workbook?
Please keep in mind: avoid the registry unless you have a full system backup and a separate copy of the registry.
Also, note that an archive is mentioned, along with Windows 7.
Reference: https://www.lifewire.com/xlam-file-...opened,Office Compatibility Pack is installed