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
|
|||
|
|||
Opening saved Excel files
When I open any saved Excel file the program will open a blank 'Book 1' and
then open my pre-existing spreadsheet in a new window - how can I stop Excel opening a blank Book 1? I am using Office Pro 2003 and file share on my PC and wirelessly networked laptop - Excel opens files on both the PC where I save my docs and on the laptop in the same way. Ray |
#2
|
|||
|
|||
Opening saved Excel files
If you are first opening Excel and then opening the desired workbook,
creating Book1.xls is normal. If you're opening the workbook by using Windows Explorer and finding the .xls file and double-clicking to open it directly, then it's not. You may have a Book1.xls in your XLStart folder. But to start Excel without the splash screen and without automatically creating an empty Book1.xls follow the instructions under the Excel Help topic Customize how Excel starts and look in the sub-topic Use startup switches when you start Excel which will tell you how to do it all, which boils down to using the /e switch in the shortcut opening Excel to prevent display of the startup screen and a new blank workbook. "Ray" wrote: When I open any saved Excel file the program will open a blank 'Book 1' and then open my pre-existing spreadsheet in a new window - how can I stop Excel opening a blank Book 1? I am using Office Pro 2003 and file share on my PC and wirelessly networked laptop - Excel opens files on both the PC where I save my docs and on the laptop in the same way. Ray |
#3
|
|||
|
|||
Opening saved Excel files
Cheers, thanks for your help.
"JLatham" wrote in message ... If you are first opening Excel and then opening the desired workbook, creating Book1.xls is normal. If you're opening the workbook by using Windows Explorer and finding the .xls file and double-clicking to open it directly, then it's not. You may have a Book1.xls in your XLStart folder. But to start Excel without the splash screen and without automatically creating an empty Book1.xls follow the instructions under the Excel Help topic Customize how Excel starts and look in the sub-topic Use startup switches when you start Excel which will tell you how to do it all, which boils down to using the /e switch in the shortcut opening Excel to prevent display of the startup screen and a new blank workbook. "Ray" wrote: When I open any saved Excel file the program will open a blank 'Book 1' and then open my pre-existing spreadsheet in a new window - how can I stop Excel opening a blank Book 1? I am using Office Pro 2003 and file share on my PC and wirelessly networked laptop - Excel opens files on both the PC where I save my docs and on the laptop in the same way. Ray |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sharing read-write Excel 2003 files | ttt8262 | General Discussion | 0 | April 1st, 2006 09:39 PM |
Opening multiple Excel files that contain varied selected sheets | MLBrownewell | Worksheet Functions | 0 | September 14th, 2005 05:48 PM |
How to auto start a new Excel image or window when opening files | Robert in Phoenix | Setting up and Configuration | 5 | May 30th, 2005 12:09 AM |
Excel opening all files in root of C: when launching | yarbrough2 | General Discussion | 1 | March 31st, 2005 12:08 AM |
Problem Opening Excel files | Paul Bull | Setting up and Configuration | 2 | November 9th, 2003 10:29 AM |