Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / November 2005

Tip: Looking for answers? Try searching our database.

Change Excel default Workbook Template?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Matt D Francis - 21 Nov 2005 11:19 GMT
I want to same the same header/footer for all documents I produce.

I've read a few suggestions on here as to how the change the properties of
the default Workbook template, but just can't getit to work. I have tried
saving an .xlt file as Book.xlt, Sheet.xlt etc under the XLStart directory
but nothing I do seems to get picked up.

I'm using Office 2000 in WinXP.

Any suggestions?
Dave Peterson - 21 Nov 2005 15:30 GMT
Depending on how you've upgraded versions of excel, you may have multiple
XLStart folders.

To find the "current" XLStart folder, I'd do this:

Start excel
hit alt-f11 (to get to the VBE)
hit ctrl-g  (to see the immediate window)
type this and hit enter:
?application.StartupPath

Then make a note of that folder.

Now close excel

windows start button|search
look for XLStart
Go into each one consolidate what you want to keep into that "current" folder.
You may want to just move those files in the various XLStart folders to a nice
safe location.

Now back to excel and create a workbook template and save it as book.xlt (as a
template) in that current XLStart folder.

Now when you click the New icon on the standard toolbar, you'll get a new
workbook based on this template.

> I want to same the same header/footer for all documents I produce.
>
[quoted text clipped - 6 lines]
>
> Any suggestions?

Signature

Dave Peterson

Gord Dibben - 21 Nov 2005 20:36 GMT
Note Dave states "when you click on the New icon you'll get a new workbook
based on this template"

That is correct.

Also File>New(no ellipsis)

If you go to File>New... and "blank workbook" you will not get your altered
BOOK.xlt.  You will open the Excel default workbook.

Gord Dibben Excel MVP

>Depending on how you've upgraded versions of excel, you may have multiple
>XLStart folders.
[quoted text clipped - 33 lines]
>>
>> Any suggestions?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.