How do you change the Excel Personal Macro Workbook Location in Excel 2010? Wanting to keep it stored on server rather than locally on the computer. Thanks.

Hi,

Based on my tested, please try the following workaround:

1) Find the Excel Personal Macro Workbook with following path: C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART.

2) Copy it to a new server folder.

3) Open Excel 2010> Click Option>Advanced>General>At startup, open all files in> Type the folder path of the Excel Personal Macro Workbook

Regards,

George Zhao
TechNet Community Support

Didn't seem to help, but went a different route that seems to be working.

• Marked as answer by Joe-FSS Wednesday, May 07, 2014 10:40 PM

hi - i know this is old thread but can you please share what is this other route that worked for you?

Thanks,

Brij