Changing The Excel Personal Macro Workbook Location
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.
May 6th, 2014 8:10pm

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



Free Windows Admin Tool Kit Click here and download it now
May 7th, 2014 6:23am

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
May 7th, 2014 10:40pm

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

Thanks,

Brij

Free Windows Admin Tool Kit Click here and download it now
September 8th, 2015 6:18pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics