logo

Previous Thread:   Delete a row and inset a row - Lotus equivalent

6/23/2005 5:41:02 AM    default blank excel document??
Hello all.  
  
I am trying to find out what the default Excel document is. Word has the  
  
default.dat but what does Excel have? I have a user who had a problem and the  
  
tech who "fixed" the problem replaced the default document with two other  
  
documents. I have cleared out the XLSTART folder and that didnt work.  
  
Please, any and all replies welcome and appreciated.

6/23/2005 7:56:31 AM    Re: default blank excel document??
MSWord has Normal.dot.  
  
Excel has book.xlt.  It's a workbook that's set up the way you want and saved as  
  
a template in your XLStart folder.  
  
Excel also has a sheet.xlt template workbook.  It's used when you add a new  
  
worksheet to an existing workbook.  
  
If you want to find out where that folder is:  
  
Open excel  
  
hit alt-f11 to get to the VBE (where macros live)  
  
hit ctrl-g  to see the immediate window.  
  
type this and hit enter:  
  
?application.StartupPath  
  
For me (winXP and xl2003), I get:  
  
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART  
  
Scott wrote:  
  
--  
  
Dave Peterson

6/23/2005 6:52:05 PM    Re: default blank excel document??
You can just start a new workbook and modify it the way you want.  
  
Then save to that XLStart folder.  
  
(You could copy from another pc if you want, too.  Whichever is easiest.)  
  
Scott wrote:  
  
--  
  
Dave Peterson