If you open a workbook in xl2k and higher, then do file|SaveAs, excel will go to
the folder that held the original workbook.

If that user wants to change the layout, then she should be using a template
file (*.xlt). Then excel will use the default file location as the save
location.

Is there a reason she doesn't want to use a template file--that technique is
pretty normal for most people.

Beach Lover wrote:

Using Excel 2003 and changed the startup layout of the workbook (changed
background color and added borders on all cells). Also changed the default
save location as well as auto recover location to the network. Until today,
when user opened Excel it opened correctly and she could click the save
button and it would automatically point to the network. Now, it is
overwriting the startup document. Any suggestions as to why this is
happening and how to correct. She doesn't want to use a template....just
wants to open Excel and have it look the way she wants immediately.

--

Dave Peterson