Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Win 7 "broke" my Excel Add in

13 Dec 2009   #1
kriemer

Win 7
 
 
Win 7 "broke" my Excel Add in

It appears that Microsoft in their less than infinite wisdom have changed the default Excel 2003 add-in file location. I have also found that my existing spreadsheets that use a stock retrieval add-in (and perhaps others) fail; as the location of that add-in is coded into the spreadsheet.

The result of all this is that I need to rebuild many, many, etc., spreadsheets as a consequence of my move to Win 7. This also means that the spreadsheets are not transferable between machines running the 2 different operating systems.

Is there any fix to this issue?

Apologies if this is more of an Excel issue than a Win 7 issue.

Regards


My System SpecsSystem Spec
.
13 Dec 2009   #2
Barman58

Windows 10 Pro x64 x2 Windows 10 Enterprise x64, Ubuntu
 
 

I am surprised that this is happening as win7 uses virtualisation technology to specifically deal with this issue.

Can you let me know what the original location is and if possible the new location and I will see if it is a re-direction issue or maybe a protection issue. win7 by default provides far better protection to system areas, and if the add-in is pointing to a protected area this will need to be addressed
My System SpecsSystem Spec
13 Dec 2009   #3
kriemer

Win 7
 
 

Win XP default Excel add in location:
C:\Documents and Settings\USERXXX\Application Data\Microsoft\AddIns

Win 7 default Excel add in location:
C:\Users\USERXXX\AppData\Roaming\Microsoft\AddIns

I sure hope there's a solution to this.

Thanks in advance

k
My System SpecsSystem Spec
.

13 Dec 2009   #4
Barman58

Windows 10 Pro x64 x2 Windows 10 Enterprise x64, Ubuntu
 
 

this is confusing Win7 includes a junction point for this very purpose pointing all requests for C:\Documents and Settings\USERXXX\Application Data.... to C:\Users\USERXXX\AppData\Roaming.... so this should work without modification.

What error message do you receive, or does the application just fail?
My System SpecsSystem Spec
13 Dec 2009   #5
kriemer

Win 7
 
 

The application (spreadsheet) just fails.

k
My System SpecsSystem Spec
13 Dec 2009   #6
Barman58

Windows 10 Pro x64 x2 Windows 10 Enterprise x64, Ubuntu
 
 

Assuming that the Add-on is located in the correct place then I can only assume that this is an issue with Windows 7

I have come across this partly related page from Microsoft, relating to %appdata%, the location we are dealing with here, which suggests that similar errors may be corrected by changing the Path environmental variable in XP.

Manually adding the full location to the "path" EV may get the spreadsheets to work without modification


Environment variable may not expand %APPDATA% to the Application folder
My System SpecsSystem Spec
13 Dec 2009   #7
kriemer

Win 7
 
 

I am not sure what you mean by "...which suggests that similar errors may be corrected by changing the Path environmental variable in XP".

Where does XP come into the equation?

Thanks

k
My System SpecsSystem Spec
13 Dec 2009   #8
Barman58

Windows 10 Pro x64 x2 Windows 10 Enterprise x64, Ubuntu
 
 

Ok I don't have office 2003, available to test here (which I am assuming you are running on Win7 as well as XP machines).

I have tested the %appdata% variable in win7 and using XPmode and they point to the correct locations relevant to the OS .

If you change the link address in excel to read "%appdata%\microsoft\AddIns" (plus the actual add-in detail if needed), the spreadsheet should be able to find the actual add in.
My System SpecsSystem Spec
13 Dec 2009   #9
Barman58

Windows 10 Pro x64 x2 Windows 10 Enterprise x64, Ubuntu
 
 

Additional testing produces the following in my system

Running a command prompt

Code:
c:\>cd C:\Documents and Settings\nigel\Application Data\Microsoft\AddIns

C:\Documents and Settings\nigel\Application Data\Microsoft\AddIns>dir
 Volume in drive C is W7 Pro x64
 Volume Serial Number is 04EE-D94A

 Directory of C:\Documents and Settings\nigel\Application Data\Microsoft\AddIns

22/08/2009  12:41    <DIR>          .
22/08/2009  12:41    <DIR>          ..
13/12/2009  18:52                 0 Test document in appdata roaming.TXT
               0 File(s)              0 bytes
               2 Dir(s)  40,010,432,512 bytes free

C:\Documents and Settings\nigel\Application Data\Microsoft\AddIns>
Which illustrates that the original path is valid in win7 and points to the new location as the test document shown is is the new addins folder
My System SpecsSystem Spec
13 Dec 2009   #10
kriemer

Win 7
 
 

Barman 58

You are right the WinXP path is valid (I'm not able to run in XP mode & it is still there). When I try pointing to the add in in this directory Excel returns to the Win 7 default. Sigh...

I guess at some point I will see the reason/advantage of the junction point/node structure Win 7 works under.

Thanks 10^6

k
My System SpecsSystem Spec
Reply

 Win 7 "broke" my Excel Add in




Thread Tools




Similar help and support threads
Thread Forum
Make Excel 2010 Automatically Organize by Column "A" with Header
Hi all, I'm working on an excel spreadsheet for my passwords. My columns are labeled website, username and password, respectively. I know how to go to data>sort to sort what I have so far, but is there a way for me to be able to put a new website, username and password at the bottom of the list,...
Microsoft Office
"Office [2013] is busy," then quick repair broke it further?
I got an error message trying to open Office 2013 saying it was busy. After a quick online search, I tried using the Repair feature in Programs and Features. Online Repair gave an error that it didn't work before even getting past Step 1 of 4, and Quick Repair stopped working mid-way through and...
Microsoft Office
Excel 2010 "File In Use" notification doesn't show
Hello! We have shared folder on server that specific users can open it. In that folder there are bunch of excel files that they need to fill in. Problem starts when one user opens the document and starts filling the excel file, in that moment other user opens the same excel file but doesn't get...
Microsoft Office
How to edit/delete "Comments" in Excel 2010 Starter?
I'm working with a 1997-2003 Compatibility View spreadsheet in Excel Starter and I use Comments (the little windows to pop-up when you hover the mouse over a cell) throughout. I don't see how to edit or delete them, when I right-click, it only gives me "show/hide" them. Thanks!
Microsoft Office
EasyBCD 2.1.2 "broke" Bootloader and can't acess Win 7 (black screen)
Hi guys, I've a ASUS N56VZ with Intel Core i7 - 3610QM, with Win 7 Home Premium x64 pre-installed. This computer come with EFI instead of the traditional BIOS. When I bought it, I had 3 visible partitions. C (OS) - with windows and programs; D (Data) - in blank, I store some movies and other...
Installation & Setup
microsoft excel "Trial period has expired, request new template"
This is a fully activated TechNet Office Pro Plus 2010 which is generating this message when trying to save a spreadsheet only, not with Word Doc.
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 12:38.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App