#1   Report Post  
Posted to microsoft.public.excel.misc
tx.turtle
 
Posts: n/a
Default Opening Excel

I accidentially overwrote the blank worksheet that automatically appears when
opening Excel. How do I reset this or even better how can I get no worksheet
to display when I open Excel?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Opening Excel

There's a workbook template named book.xlt that is located in your XLStart
folder.

You should be able to open it, edit it and save it the way you like.

If you really don't want to use it, just delete it.

To keep excel from creating that workbook when you open excel, you can create a
new shortcut to excel and use that. But you have to add a parameter telling
excel not to create that new worbook.

Create a new shortcut to excel.exe
But add /e (spacebar slash e) to the end of the target.

excel.exe /e
or
"C:\yourpathto\excel.exe" /e

If you look in xl's help for "Customize how Excel starts", you'll see more info.

tx.turtle wrote:

I accidentially overwrote the blank worksheet that automatically appears when
opening Excel. How do I reset this or even better how can I get no worksheet
to display when I open Excel?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default Opening Excel

There is also a sheet.xlt template which is used whten adding worksheets to
and *existing* worksheet or to your workbook in addition to the number of sheets
you originally requested.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem opening excel files from email DXC001 Excel Discussion (Misc queries) 1 October 3rd 05 07:56 PM
Keep Excel from opening new instance widman Excel Discussion (Misc queries) 7 October 1st 05 01:53 AM
Error message opening Excel Ed Excel Discussion (Misc queries) 1 March 18th 05 04:04 AM
Trouble opening an Excel file that contains macros JohnR Excel Worksheet Functions 1 March 8th 05 08:09 PM
Opening an Excel file Sheldon Zaklow Excel Discussion (Misc queries) 0 March 3rd 05 10:29 PM


All times are GMT +1. The time now is 12:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"