If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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: 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. -- Dave Peterson |
#3
|
|||
|
|||
Ooppss... it is normal.dot.. I had a brainfart when I did typed that.
What would I do to get a regular blank excel spreadsheet book to replace those templates? Do I have to go in and edit the book that is in there and save it as a book.xlt? Then place it in the XLSTART folder? Or can I find one on a default machine that I can copy and put on his machine? Please let me know when you get a chance. All help and advise is appreciated. Scott "Dave Peterson" wrote: 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: 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. -- Dave Peterson |
#4
|
|||
|
|||
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: Ooppss... it is normal.dot.. I had a brainfart when I did typed that. What would I do to get a regular blank excel spreadsheet book to replace those templates? Do I have to go in and edit the book that is in there and save it as a book.xlt? Then place it in the XLSTART folder? Or can I find one on a default machine that I can copy and put on his machine? Please let me know when you get a chance. All help and advise is appreciated. Scott "Dave Peterson" wrote: 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: 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. -- Dave Peterson -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to embed Word document into Excel and retain sizing, formatti. | Kent | General Discussion | 0 | February 2nd, 2005 07:37 PM |
Prevent Blank Records being written. Need Help. | Robert Nusz @ DPS | Using Forms | 4 | December 29th, 2004 05:15 PM |
Default Document Screen View | gmoseley | General Discussion | 13 | November 9th, 2004 04:00 AM |
Can't edit Excel document in browser with macros | wanderso | General Discussion | 0 | June 16th, 2004 06:10 PM |
Default File Location | Derek Ruesch | Setting up and Configuration | 6 | January 30th, 2004 03:03 AM |