PDA

View Full Version : Start Excel 2007 with an empty worksheet



evamads
07-13-2009, 12:37 AM
Hello Everybody,
I've been reading though various threads and can't quite seem to find one that does what I need: I want Excel to start with an empty workbook. Some months ago, I have been experimenting with having Excel to start without an empty workbook, and succeeded!!!

But now I don't remember what I did :doh:

Any suggestions?

Thanks in advance

/evamads

mdmackillop
07-13-2009, 12:43 AM
A book will always have one visible worksheet.

evamads
07-13-2009, 01:00 AM
Yes, I understand that. But when I start Excel 2007, it starts up empty, with no files (or worksheets) at all - i.e. I will have to click Office-button, New, and select a template before I can start working.

mdmackillop
07-13-2009, 01:27 AM
Save a workbook calleds Book.xls (or 2007 equivalent) in your XLStart folder.

Bob Phillips
07-13-2009, 01:34 AM
You can also customise a workbook and save it as book.xlt there, that way all new books will adopt this custom style.

evamads
07-13-2009, 02:00 AM
Yes, that works - thank you.

But it opens the actual Book.xltx, and what I want is Excel to open an empty (not saved) workbook, as Excel standard usually does (and like Word and PowerPoint does).

Bob Phillips
07-13-2009, 02:35 AM
What is the difference between an empty workbook and a saved workbook with nothing in it?

mdmackillop
07-13-2009, 03:49 AM
I suspect this needs an appropriate switch to the command line used by the Excel startup shortcut, and you would need to specify macro or non-macro workbook.