Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2007

Tip: Looking for answers? Try searching our database.

How do I prevent excel from opening with a blank worksheet?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
WmScott - 15 Mar 2007 14:39 GMT
I rarely start a new spreadsheet from scratch...most of the time I want to
just open Excel, but with no blank/template loading automatically.  Where do
I set this switch...maybe in the Registry??!  thanks in advance
Dave Peterson - 15 Mar 2007 15:34 GMT
You can create a new shortcut and use that.

Use something like this as the target:
"C:\yourpathto\excel.exe" /e

> I rarely start a new spreadsheet from scratch...most of the time I want to
> just open Excel, but with no blank/template loading automatically.  Where do
> I set this switch...maybe in the Registry??!  thanks in advance

Signature

Dave Peterson

NanaSharon - 24 May 2007 20:58 GMT
I have the same problem. I tried doing what you suggested and it didn't work
for me or either I did it wrong...HELP!

> You can create a new shortcut and use that.
>
[quoted text clipped - 4 lines]
> > just open Excel, but with no blank/template loading automatically.  Where do
> > I set this switch...maybe in the Registry??!  thanks in advance
Bob I - 24 May 2007 21:30 GMT
See Excel Help and look up
Customize how Excel starts
for "Stop a workbook........."

> I have the same problem. I tried doing what you suggested and it didn't work
> for me or either I did it wrong...HELP!
[quoted text clipped - 7 lines]
>>>just open Excel, but with no blank/template loading automatically.  Where do
>>>I set this switch...maybe in the Registry??!  thanks in advance
Don Guillett - 24 May 2007 21:32 GMT
Here's mine. Did you forget the space
"C:\Program Files\microsoft office2003\OFFICE11\EXCEL.EXE" /e

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I have the same problem. I tried doing what you suggested and it didn't
>work
[quoted text clipped - 10 lines]
>> > Where do
>> > I set this switch...maybe in the Registry??!  thanks in advance
Gary''s Student - 15 Mar 2007 15:36 GMT
This procedure clears all ways in which a workbook could be loaded.

On the Tools menu, click Options, and then click the General tab.
Clear the contents of the At startup, open all files in box.

Remove workbooks stored in the XLStart folder.

In Windows Explorer, remove the icon of the workbook you want to open in an
alternate startup folder.

Remove a startup switch from the Excel icon.

Right-click the Excel icon that you want to use to open Excel, and clear the
contents of the Target box.

Signature

Gary''s Student
gsnu200710

> I rarely start a new spreadsheet from scratch...most of the time I want to
> just open Excel, but with no blank/template loading automatically.  Where do
> I set this switch...maybe in the Registry??!  thanks in advance
James Silverton - 15 Mar 2007 16:12 GMT
Gary''s  wrote  on Thu, 15 Mar 2007 07:36:02 -0700:

Gs> On the Tools menu, click Options, and then click the
Gs> General tab. Clear the contents of the At startup, open all
Gs> files in box.

Gs> Remove workbooks stored in the XLStart folder.

Gs> In Windows Explorer, remove the icon of the workbook you
Gs> want to open in an alternate startup folder.

Gs> Remove a startup switch from the Excel icon.

Gs> Right-click the Excel icon that you want to use to open
Gs> Excel, and clear the contents of the Target box.

That does not seem to work. The target is a greyed out
Microsoft Office XP Professional that I cannot change. The Start
in: box is empty.

??>> I rarely start a new spreadsheet from scratch...most of
??>> the time I want to just open Excel, but with no
??>> blank/template loading automatically.  Where do I set this
??>> switch...maybe in the Registry??!  thanks in advance

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
cyndiwise notsowise - 24 Mar 2007 02:10 GMT
Since I upgraded to Excel 2007 the Tools/Options choice does not exist
anymore. I have opened the Options box but I could not find a way to prevent
a blank worksheet from opening on startup. Please tell me how to accomplish
this in Excel 2007; it is very annoying when I just want to open an existing
file. Thanks.

> This procedure clears all ways in which a workbook could be loaded.
>
[quoted text clipped - 14 lines]
> > just open Excel, but with no blank/template loading automatically.  Where do
> > I set this switch...maybe in the Registry??!  thanks in advance
Stan Brown - 24 Mar 2007 14:35 GMT
Fri, 23 Mar 2007 18:10:00 -0700 from cyndiwise notsowise
<cyndiwisenotsowise@discussions.microsoft.com>:
> Since I upgraded to Excel 2007 the Tools/Options choice does not exist
> anymore. I have opened the Options box but I could not find a way to prevent
> a blank worksheet from opening on startup. Please tell me how to accomplish
> this in Excel 2007; it is very annoying when I just want to open an existing
> file. Thanks.

If you just want to open an existing file, double-click the file
instead of starting Excel yourself.

Signature

Stan Brown, Oak Road Systems, Tompkins County, New York, USA
                                 http://OakRoadSystems.com/

NanaSharon - 25 May 2007 19:50 GMT
You can't do this in 2007

> This procedure clears all ways in which a workbook could be loaded.
>
[quoted text clipped - 14 lines]
> > just open Excel, but with no blank/template loading automatically.  Where do
> > I set this switch...maybe in the Registry??!  thanks in advance
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.