ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Default Save To directory doesn't work Excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/78537-default-save-directory-doesnt-work-excel-2003-a.html)

[email protected]

Default Save To directory doesn't work Excel 2003
 
I have a template that is set to be used every time Excel 2003 is
started up. The template's called book.xlt and it's saved in the
designated XLSTART folder. As I expect, when I start up Excel, I get a
new spreadsheet called book.xls. On the Tools - Options - General tab,
the program is set to save in the My Documents folder as default.
However, if I try to "save" or "save as" the book.xls folder, Excel
shows the XLSTART directory as the default folder for saving
spreadsheets. How can I get the program to save this BOOK.XLS folder in
the designated save-to directory (My Documents)?


Dave Peterson

Default Save To directory doesn't work Excel 2003
 
It actually sounds like you have a book.xls in that XLStart folder.

When you create a workbook using book.xlt, you shouldn't see an extension at
all. You should see book1 (or book# when you do it again...)

I'd look in the XLStart folder for extra junk.

" wrote:

I have a template that is set to be used every time Excel 2003 is
started up. The template's called book.xlt and it's saved in the
designated XLSTART folder. As I expect, when I start up Excel, I get a
new spreadsheet called book.xls. On the Tools - Options - General tab,
the program is set to save in the My Documents folder as default.
However, if I try to "save" or "save as" the book.xls folder, Excel
shows the XLSTART directory as the default folder for saving
spreadsheets. How can I get the program to save this BOOK.XLS folder in
the designated save-to directory (My Documents)?


--

Dave Peterson


All times are GMT +1. The time now is 05:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com