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

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

Windows 7 Ultimate x64 x2 + x86 + Windows 8.1 x64 x2
 
 

I am surprised that this is happening as Windows 7 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. Windows 7 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

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

Windows 7 Ultimate x64 x2 + x86 + Windows 8.1 x64 x2
 
 

this is confusing Windows 7 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

Win 7
 
 

The application (spreadsheet) just fails.

k
My System SpecsSystem Spec
13 Dec 2009   #6

Windows 7 Ultimate x64 x2 + x86 + Windows 8.1 x64 x2
 
 

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

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

Windows 7 Ultimate x64 x2 + x86 + Windows 8.1 x64 x2
 
 

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

I have tested the %appdata% variable in Windows 7 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

Windows 7 Ultimate x64 x2 + x86 + Windows 8.1 x64 x2
 
 

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 Windows 7 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 Windows 7 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

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




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:48 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33