Save As excel - file location

[MetLife]

Hi,

When I choose, save as using excel it chooses a file location for me, then I have to browse to another place.

How can I change this to automatically save on C:\metlife?

It must be somewhere in File->options but I can't locate it.

Thanks!

 

[Fluff]

File > Options > Save > Default local file location > C:\metlife
But if you save a file elsewhere, it will overwrite the default until you close & re-open xl

 

[MetLife]

OK thanks.

For some reason, every time I try to "save as" excel crashes. Maybe this has to do with the fact that the location is on my work server and this causes some instability.