» Opening a template file automatically upon starting Microsoft Excel
CATEGORY: Excel Data , Excel Counting |
VERSIONS: All Microsoft Excel Versions |
|
There are two options for opening a workbook template automatically upon starting Excel. First option Save a workbook name Book.xlt ( in Excel 2000 name the book Sheet.xlt), which you customized, in the sub-folder XlStart. When Excel is started, a customized workbook Book1.xls (or Sheet1.xls in Excel 2000) is opened from within the template you saved, instead of the standard Book1.xls. The XlStart sub-folder is located in the same folder as the Office program on the hard drive. To open a new workbook, press Ctrl+N or in the Standard toolbar, click the New icon. Second option Save the template file you created as MyWorkbook.xlt in any folder, and enter the name of the workbook template in the Options dialog box.
Note Do not use the two selected options simultaneously, unless you have created more than one workbook. Use only one of the two options (Excel tries to open the file with the same name twice). |
Book Store:
Recommended Books:
- The Fall of Advertising and the Rise of PR
- Advanced modelling in finance using Excel and VBA
- Analyzing Markets, Products, and Marketing Plans
- Financial Risk Manager Handbook, Second Edition
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.





