Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I prevent excel from opening with a blank worksheet?

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How do I prevent excel from opening with a blank worksheet?

You can create a new shortcut and use that.

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



WmScott wrote:

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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default How do I prevent excel from opening with a blank worksheet?

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.

--
Gary''s Student
gsnu200710


"WmScott" wrote:

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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 182
Default How do I prevent excel from opening with a blank worksheet?

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

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default How do I prevent excel from opening with a blank worksheet?

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.

"Gary''s Student" wrote:

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.

--
Gary''s Student
gsnu200710


"WmScott" wrote:

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



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 524
Default How do I prevent excel from opening with a blank worksheet?

Fri, 23 Mar 2007 18:10:00 -0700 from cyndiwise notsowise
:
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.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default How do I prevent excel from opening with a blank worksheet?

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!

"Dave Peterson" wrote:

You can create a new shortcut and use that.

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



WmScott wrote:

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

  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default How do I prevent excel from opening with a blank worksheet?

See Excel Help and look up
Customize how Excel starts
for "Stop a workbook........."


NanaSharon wrote:

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!

"Dave Peterson" wrote:


You can create a new shortcut and use that.

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



WmScott wrote:

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


  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default How do I prevent excel from opening with a blank worksheet?

You can't do this in 2007

"Gary''s Student" wrote:

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.

--
Gary''s Student
gsnu200710


"WmScott" wrote:

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

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
Prevent worksheet from opening in a workbook laurenm Excel Worksheet Functions 5 January 18th 07 05:42 AM
how do i get excel to stop opening a blank worksheet @ startup? lady_gemini1971 Excel Discussion (Misc queries) 5 October 18th 06 11:38 PM
Opening an excel file returns a blank worksheet JVenner Excel Discussion (Misc queries) 4 October 15th 06 02:27 AM
prevent blank cell in excel worksheet jatman Excel Worksheet Functions 1 July 29th 06 03:08 PM
Open Excel App without a blank worksheet opening Chris Excel Discussion (Misc queries) 2 September 14th 05 01:46 AM


All times are GMT +1. The time now is 10:50 AM.

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

About Us

"It's about Microsoft Excel"