Tech Support Guy banner
Status
Not open for further replies.
1 - 5 of 5 Posts

· Registered
Joined
·
142 Posts
Discussion Starter · #1 ·
It seems to me that I used to be able to set up my own default Excel books and worksheets. I would set formats, toolbars, footers, etc. the way I liked them then save the sheet as “sheet1.xlt” and the workbook as “book1.xlt”, and put these in the XLstart folder. That way, when I opened a new workbook, or inserted a new sheet, the sheets are formatted they way I want them. But that doesn’t seem to work now. I’m using Excel 97 and Win XP. Before I was using Excel 97 and Win98. Did I miss a cog somewhere? It’s been a long time since I did this and perhaps I missed a step.

Don
 

· Registered
Joined
·
11,836 Posts
And you don't save a sheet1.xlt--there is no such thing.

Just right-click on sheet1 of a blank file, hit Select all sheets. Format as desired. Save the file as book1.xlt in the XLSTART. Close Excel and relaunch to test.

(Hi mikey!)
 

· Registered
Joined
·
142 Posts
Discussion Starter · #5 ·
The correct name is book.xlt. Furthermore, if there is more than one sheet in your book be sure all are formatted the way you want them. For example, if you want your own footer to appear on each sheet you must add it to each sheet, then save the template. Also, if you want Inserted sheets to be set up the same way, then go to Save As and save "sheet.xlt". It works just like book.xlt in that it saves your settings for inserted sheets. One other thing: My Excel default for saving Excel templates is "Microsoft Office/Templates". Unfortunately, Excel looks for its templates in "Microsoft Office/Office/XLStart". Be sure and save your Excel templates there.

Don
 
1 - 5 of 5 Posts
Status
Not open for further replies.
Top