Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Workbooks > Startup Switches< Previous | Next > 

 

What is a Startup Switch ?

 
 

When you open Excel a lot of the settings are read from the Windows Registry, including details of any built-in add-ins that are currently installed.

 
 

There are a number of command line switches that can also be used to affect the way that Excel starts.

 
 

These switches can be added to the Properties of a shortcut that starts Excel.

 
 
/automationOpens Excel ignoring any add-ins, templates or files that are in the "xlStart directory" and the "At start-up open all files in" directory.
/eOpens Excel in Embedded mode which prevents the default workbook Book1 from being created.
/embeddedSame as above
/iOpens Excel with a maximised window. Any previously saved window sizes are ignored.
/IOpens Excel and loads a particular add-in.
/mOpens Excel with a new workbook containing a single Excel 4.0 macro sheet. This is now redundant.
/oOpens Excel forcing it to re-register itself in the Window Registry.
/p folderpathUsed when specifying a folder to be used as the default folder.
/r filepathOpens Excel with a specific file in read-only mode. You must include the path and filename afterwards.
/regserverForces Excel to re-register itself in the Windows Registry and then quit.
/sOpens Excel ignoring any add-ins, templates or files that are in the "xlStart directory" and the "Alternate Startup" directory.
/safeSame as above
/safemodeSame as above
/unregserverForces Excel to unregister itself in the Windows Registry and then quit.
 

 

Using (Start > Run)

 
 

The easiest way to run Excel with additional switches is to use the Command Line.

 
 

All you need to do is select (Start > Run) and type the full folder path of the Excel.exe file.

 
 

This folder path needs to be enclosed in parentheses with the corresponding startup switch added afterwards.

 
   

 

Things to Remember

 
 
  • Any files that are in the "xlstart" directory will be opened automatically instead of the blank workbook.

     

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >