Excel Startup Default and Alternate locations problem
Posted on 2015-02-06
We have a GlobalFunctions.xla that we push out to all our users pc's into their C:\Users\username\AppData\Roaming\Microsoft\Excel\XLSTART that contains global functions that are available to the whole business. All works fine.
We've been bought out and are in the process of moving to the new companies infrastructure which is all thin client citrix based. As i understand it and have been told there is no AppData\Roaming available as there is no C: drive so the GlobalFunctions.xla has been specified in the Alternatate Location in the File\Options\Advanced setting within Excel. If I open Excel and hit Alt+F11 I can see that the GlobalFunctions has loaded. So far so good.
Here's the problem, Book1.xls created and saved on the old set up has a link to GetFactor (function within GlobalFunctions.xls) however, when we copy this to the new structure and open the workbook the GetFactor() is replaced with C:\Users\username\AppData\Roaming\Microsoft\Excel\XLSTART!GetFactor() So it looks like it's looking for the function from the default location rather than the alternative location ??
If i remove the C:\Users\username\AppData\Roaming\Microsoft\Excel\XLSTART! and save the spreadsheet it works and works each time i open it, so that leads me to believe there's some kind of internal reference to the original location of the GlobalFunctions ??
Any help appreciated.