Get an in-depth look at the startup parameters of Excel

In Excel, the system sets up a number of optional startup parameters that enable users to easily customize the startup options for Excel. Because there are fewer articles in this area and many friends don't understand the startup parameters of Excel and their meaning, this article lists all the startup parameters for Excel and describes the specific features of each parameter, as well as two ways to use Excel to start parameters. I hope the introduction of this article will help you with these startup parameters.

First, the Excel starts the parameter and the explanation

/e: Use this parameter to force Excel to not display the splash screen at startup, or to create a new workbook (Book1.xls).

/m: Force Excel to create a new workbook that contains only a single macro sheet.

/o: Force Excel to re-register and write the registration entries to the following items in the registry: Hkey_current_usersoftwaremicrosoftoffice8.0excel

/p + Folder path folder name: Forces Excel to use the specified path instead of the default path as the current path. For example,/p "C:My Excel".

/r + Folder path file name: Forces Excel to open a specified workbook file as read-only. For example,/R "C:My Documents12345.xls", you can force Excel to open a read-only "12345.xls" workbook in the C:My Documents folder.

/s: Start Excel using Safe mode. You will see the word "Safe mode" in the Excel title bar and start Excel in Safe mode as if it were first started after installation.

When you start Excel using Safe mode, the following is skipped:

(1) All files in any Excel startup folder.

(2) Add-ins: Although the Add-ins dialog box still displays the selected add-in, Excel does not load any of the add-in macros.

(3) Excel toolbar (Excel.xlb or < username >.xlb): Excel will use the original installation default toolbar settings.

(4) Excel-specific registry information: The Install default registry settings will be used.

Note: When Excel is in Safe Mode, the Options dialog box displays the system defaults instead of displaying user-defined settings.

/RegServer: Force Excel to re-register, and then quit Excel. You can use this startup parameter if you want Excel to rewrite all the registry entries and re-establish the association with Excel files such as workbooks, charts, and so on.

/unregserver: Force Excel to unregister and exit.

Description

(1) Excel's startup parameters are case-insensitive, such as the use of the "/e" and "/e" parameters in the same way. In some cases, you can use more than one startup parameter at a time, and when you use multiple startup parameters at the same time, you must separate each startup parameter with a space, for example: "/O/S".

(2) in the text above the parameters of the ":" Do not have to type, the same below.

Two methods of using Excel as parameters

After you know the startup parameters above, let's look at how to use:

1. Add startup parameters in Excel Quick run mode

If you always want to force Excel to start without displaying a splash screen or creating a new workbook, you can add the/e startup parameter to the shortcut run of Excel, which is set up by using the Windows 98 operating system as an example:

(1) Right-click the "Start" button in the lower-left corner of the Window98 screen, and then click Open on the shortcut menu that opens.

(2) In the Open new window, double-click the Programs folder, expand it, right-click the Microsoft Excel shortcut, and then click Properties on the shortcut menu that opens.

(3) Click the Shortcuts tab, and then type the startup parameters you want to use after the Excel.exe Run command in the target input box. For example, in this case we need to add the "/e" startup parameter, and then you need to type the following in the target input box:

C:Program FilesMicrosoft officeofficeexcel.exe/e

If your Excel is not installed in the default path above, simply modify the path of Excel in the above content to the correct installation directory.

(4) Click "OK" button to exit.

After this setting, when you start Excel by using the Excel shortcut, the splash screen is no longer displayed, and the new workbook is not created.

Attention:

If we work under Windows 2000 or Windows XP, you may not be able to modify the Excel parameters in this way. In fact, the essence of the above method is to modify the shortcuts in Excel, for more detailed methods of modifying shortcuts, please refer to this issue of the "Let Excel workbook automatically open" article related section.

2. Use Excel parameters in "Run" mode

If you are only occasionally running Excel using the startup parameters, such as to re-establish the correct file association when an Excel file has a file association error, you can start Excel by adding startup parameters to excel in the run as command line.

(1) Click the Start button, click Run on the Start menu, and open the Run dialog box.

(2) in the "open" input box or through the "Browse" button to get Excel.exe contains all the path file name, and at the end of the command line to add the switch to use. For example, C:Program FilesMicrosoft officeofficeexcel.exe/regserver.

(3) Click the OK button, Excel executes, and all registry keys are rewritten and associated with Excel files such as workbooks, charts, and so on.

Editor:

Many newspapers have introduced the parameters of word, but there are fewer Excel introductions. Microsoft's things really profound, must learn! Of course, the small series is no exception. However, the last small series to remind you two points, you may have a start: (1) We can use the above parameters, that is, two or more than two parameters can be used at the same time, (2) We can modify the shortcut to create multiple shortcuts for Excel, and add different parameters to meet different needs, This will be convenient for many, (3) The author of this article is an example of Excel 2000, but according to the small series of experiments, found that the above parameters in Excel XP using no problem, fully compatible!