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 8.1 Pro x64 x3 + Windows 10 Preview, 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 8.1 Pro x64 x3 + Windows 10 Preview, 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 8.1 Pro x64 x3 + Windows 10 Preview, 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 8.1 Pro x64 x3 + Windows 10 Preview, 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 8.1 Pro x64 x3 + Windows 10 Preview, 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 for2: Win 7 "broke" my Excel Add in
Thread Forum
Solved Excel 2010 "File In Use" notification doesn't show Microsoft Office
Solved How to edit/delete "Comments" in Excel 2010 Starter? Microsoft Office
EasyBCD 2.1.2 "broke" Bootloader and can't acess Win 7 (black screen) Installation & Setup
microsoft excel "Trial period has expired, request new template" 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 02:36 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App