automatically adding footer info

[palfireisland]

Hi

Is there anyway to set Excel to automatically add header or footer info to every workbook created eg Path, date, filename. I basically just want to force this rather than trying to get users to remember to add this.

Thanks

 

[xapie128]

Is there anyway to set Excel to automatically add header or footer info to every workbook created

Yes:

• Start Excel with a blank workbook
  Set up the header/footer info like you want
  Do a SaveAs
  In the "Save as type" pull-down, select Template (*.xlt)
  In the "Save in" box at the top, navigate to C:\Program Files\Microsoft Office\Office10\XLStart
  (note: I'm using Excel 2002, your path may differ, but you are looking for the XLStart directory)
  Save the template with file name of Book.xlt

The next time you start Excel it will automatically have the header/footer info.

Tip: If one already exists, rename the original Book.xlt to something else so you can return to the default if desired.

 

[palfireisland]

Thanks

Excellent Thanks!