Click here for important information about

Excel Macros on TS environment

Microsoft Office 2003 professional oem
June 15, 2010 at 09:13:10
Specs: Server 2003 R2
Hi All,

We currently have a load balancing Terminal Server environment where users do not always enter the same sever as before. Excel stores macro data in an area which is not moved with the profile and therefore not on every terminal server.

Does anyone know the path to the macro data file so we can move it to the correct location on each TS?

See More: Excel Macros on TS environment

June 15, 2010 at 09:46:34
re: Does anyone know the path to the macro data file ?

I'm a bit confused. I'm not familiar with the term "macro data file". Maybe I'm missing something in your question.

Excel macros are typically stored ether in any given workbook, in which case they would be available only when that workbook is open, and/or in a file named personal.xls, which is created by the user and typically stored in the XLSTART folder.

If Excel finds a personal.xls file in the XLSTART folder, it will open it whenever Excel opens so that the macros stored in it are available in all workbooks. Typically the user would Hide the personal.xls file before saving it so that it opens Hidden and doesn't get in the way.

Do you have an XLSTART folder for every user on every TS?

What will happen when the user adds/edits a macro in his/her personal.xls file? Wouldn't it only get saved on the TS currently in use?

Having multiple copies of personal.xls, which are not in sync with each other, is going to be awfully confusing to the users. Sometimes macros will be there, sometimes not.

Am I way off base here?

Report •

June 15, 2010 at 10:16:13

I wondered if you were referring to Excel Add-Ins.
Add-Ins are used to store VB code (user-defined functions and macros).

Excel has a default location for Add-Ins, but they can be located in other locations outside the user's 'profile' area.

In a stand-alone Excel installation in Excel 2003 with the OS on drive C:, the default path is:
C:\Documents and Settings\<user name>\Application Data\Microsoft\AddIns

However in my case, for example, I store them on a different drive and not under a user name.

Like DerbyDad03, I am not familiar with the term macro data file.

If you are thinking of Add-Ins, you can search for *.xla and *.xlam files.


Report •

June 16, 2010 at 02:42:14
Macro Data File may be the incorrect term, i was trying to express a file that must contain macro information that exists on the TS.

@ DerbyDad03: Every user has an individual XLSTART on each TS, when they edit the personal.xls file it will be saved to that TS only; it must be this file i need to move for the macros to work correctly.

I will do some testing; thank you both for your assistance.

Report •
Related Solutions

Ask Question