To create a custom workbook template, type any valid file name. Type book to create the default workbook template. To create a custom workbook or worksheet template, select the Templates folder, which is usuallyĬ:\Documents and Settings\ user_name\Application Data\Microsoft\TemplatesĮnter the name of the template in the File name box. The XLStart folder is usuallyĬ:\Program Files\Microsoft Office\Office11\XLStart To create the default workbook template or default worksheet template, select either the XLStart folder or the alternate startup folder. In the Save in box, select the folder where you want to store the template. To display a picture of the first page of a template in the Preview box of the Templates dialog box ( General Templates., New Workbook task pane), click Properties on the File menu, click the Summary tab, and then select the Save preview picture check box. On the worksheet, include the formatting, styles, text, and other information you want to appear on all new sheets of the same type. Stop a workbook from loading when Excel startsĬreate a workbook that contains the sheets, default text (such as page headers and column and row labels), formulas, macros, styles, and other formatting you want in new workbooks based on the template.Ĭreate a workbook that contains one worksheet.
#DATA ANALYSIS WITH EXCEL 2003 WINDOWS#
If a Windows Installer shortcut replaces your custom shortcut, you must re-create your custom, non-Windows Installer, shortcuts. You select the Repair Office option in Maintenance Mode setup, click the Repair errors in my Office installation option, and then select the Restore My Shortcuts check box.You use the Detect and Repair command in Microsoft Office, and you selected the Repair my shortcuts while repairing check box.Note Your custom shortcut may be replaced by a Windows Installer shortcut if you name the shortcut Microsoft Excel, and either of the following are true: Move the shortcut to \Windows\Documents and Settings\Start Menu.Note The folder specified in the startup switch is used instead of the location specified in the Default file location box on the General tab ( Tools menu, Options command). Prevent display of the Excel startup screen and a new blank workbook Right-click the shortcut you created, click Properties, and then modify the path in the Target box with switches from the table.įor example, to open the workbook Actuarial Lists.xls, type a space after the path in the Target box, and then type:Ĭ:\Reference Data\Actuarial Lists.xls To start Excel and.In Windows Explorer, go to \Program Files\Microsoft Office\Office11, right-click EXCEL.exe, and click Create Shortcut.
In Windows Explorer, go to \Program Files\Microsoft Office\Office11\Shortcut Bar\Office, and then delete the shortcut for Excel.On the Start menu, point to Programs, point to Accessories, and then click Windows Explorer.