Personal.XLSB Loads from one location - Saves to another

[pdubz]

A colleague of mine is currently having an issue with their Personal.XLSB file which is used to contain many macros that are frequently updated.

When they open Excel (2007) the Personal.XLSB file is loaded from the directory:
C:\Program Files\Miscrosoft Office\Office 12\XLSSTART and they can see their Macros.

However, if/when they update a macro, close Excel and save the changes to the Personal.XLSB file when prompted these changes are saved to a version of the file in the directory:
C:\Users\username\AppData\Roaming\Microsoft\Excel\XLSSTART

So when they come to open Excel next the Personal.XSLB that's loaded is the one from Program Files and not the most up to date one from the AppData version of the file. Essentially, somehow, sometime recently these files 'branched' and it now means my colleague cannot save any updates to any Macros. I've tried deleting one and/or both of the existing Personal.XLSB files in various combinations and to get Excel to 'reset' somehow, but with no joy at all.

I would appreciate any help anyone can give to correct this so that the Personal.XSLB file loaded upon Excel startup is the same one that's saved to when closing Excel.

 

[RoryA]

If you place it only in C:\Users\username\AppData\Roaming\Microsoft\Excel\XLSTART you shouldn't have a problem.

 

[pdubz]

thanks, but I have tried that. With the Personal.XLSB file only in the users/AppData location it is not loaded at all on Excel start.

If it's in both locations it's loaded from C:\Program Files, but saves in users/AppData.

If it's only in C:\Program Files it loads from there but when you come to save it, creates a new file in users/AppData.

 

[Andrew Poulsom]

What does this return when typed in the Immediate window?

?Application.StartupPath

For me it's the expected default:

C:\Users\Andrew\AppData\Roaming\Microsoft\Excel\XLSTART

The folder in Program Files is a hangover from Excel 2003.

 

[pdubz]

What does this return when typed in the Immediate window?

?Application.StartupPath

Sorry, what do you mean by "the Immediate window"? Where should I type this?

 

[Andrew Poulsom]

The Immediate window is at the bottom right of the Visual Basic Editor. If you can't see it press Ctrl+G.

 

[RoryA]

I suspect the appdata one has been disabled. Put the only copy into the user's appdata location and then load excel, and in the options, select the add-ins section and choose to manage disabled items. See if it's listed there and re-enable it.

 

[pdubz]

Thanks, got it. Done that and the path that's shown is:

C:\Users\paul\AppData\Roaming\Microsoft\Excel\XLSTART

...as we would expect.

 

[pdubz]

I suspect the appdata one has been disabled. Put the only copy into the user's appdata location and then load excel, and in the options, select the add-ins section and choose to manage disabled items. See if it's listed there and re-enable it.

Aha! This solved the issue, very much appreciated!!!