How do I get the default workbook settings to print the date/time/

K

kuhac

How do I get the the default setting for my excel workbooks to always print
the file path, date and time? I know I can do it for an individual workbook
by changing the footer options, but is there a way to set it for all of my
excel files? A new workbook would automatically have the settings.
 
R

Ron de Bruin

Hi kuhac

You can create a empty workbook with those settings and save it as a template (xlt file) named "Book" in your xlstartfolder

If you open a new file now it use this template

Location: on my machine is
C:\Program Files\Microsoft Office\OFFICE11\XLSTART
 
G

Gord Dibben

On my machine is

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART


Gord Dibben MS Excel MVP
 
Top