How to change location of Personal file

  • Thread starter Thread starter HN007
  • Start date Start date
H

HN007

How can I change the location of the Personal file that Excel opens up
with? I do not have access to the folder where it's normally save due
to security restrictions at work.

Thanks.
 
Why do you want to change the location?

Personal Macro Workbook is stored by default in XLSTART folder which you
should have access to.

If not, talk to your IT people.

A workaround would be select Personal.xls when it is open and File>Save As

MyMacros.xls

Save it to whatever path you have in Tools>Options>General>"At start up,
open all files in"

You can change that path to wherever you want.

I don't know how will prevent Personal.xls from opening if you cannot access
XLSTART to delete the file.


Gord Dibben MS Excel MVP
 
Why do you want to change the location?

Personal Macro Workbook is stored by default in XLSTART folder which you
should have access to.

If not, talk to your IT people.

A workaround would be select Personal.xls when it is open and File>Save As

MyMacros.xls

Save it to whatever path you have in Tools>Options>General>"At start up,
open all files in"

You can change that path to wherever you want.

I don't know how will prevent Personal.xls from opening if you cannot access
XLSTART to delete the file.

Gord Dibben  MS Excel MVP
Click to expand...

Thanks this works. However, I am no longer getting the blank "Book1"
on startup.
 
Back
Top