Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Understanding Excel Files
You can install Excel in any location. But in most cases, the Excel executable file is located in the
default installation directory:
C:\Program Files\Microsoft Office\Office14\EXCEL.EXE
You can create one or more shortcuts to this executable file and customize those shortcuts’
various parameters, or command line switches. Table 4-1 lists these command line switches.
Table 4-1: Excel Command Line Switches
What It Does
Opens the specified file. The filename is a parameter and does not require a switch.
Opens the specified file in read-only mode.
Opens the specified file as a template.
Opens the specified file as a template (same as /t ).
Starts Excel without creating a new workbook and without displaying its splash
Sets the active path to a directory other than the default directory.
Starts Excel in Safe mode and does not load any add-ins or files in the XLStart or
alternate start-up file directories.
Forces Excel to create a new workbook that contains a single Microsoft Excel 4.0
macro sheet (obsolete).
You can experiment with these command line switches by using the Windows Start ➜ Run
command (or use the Search box to start the Windows Run program). Put the path to Excel in
quotes, followed by a space and the command line switch. Figure 4-1 shows an example.
One way to specify any of these switches is to edit the properties of the shortcut that starts
Excel. For example, if there are times when you’d like Excel to start and use a folder named
c:\xlfiles as its default folder, you can customize a Windows shortcut. In this case, you need
to use the /p switch and specify the folder.
Figure 4-1: Starting Excel from the Windows Run dialog box.