Saturday, May 25, 2013

How to Open a Specific Spreadsheet Each Time Excel Starts


1. Right-click the Windows desktop. Mouse over 'New' and select 'Shortcut.' The 'Create Shortcut' window will open.
2. Click the 'Browse' icon.
3. Locate and select the 'Excel.exe' file. This is the executable file that opens the Excel program. If you installed the program in the default location, the path to the file for the different versions is as follows:Excel 2003 - C:\Program Files\Microsoft Office\Office11\XlstartExcel 2007 - C:\Program Files\Microsoft Office\Office12\XlstartExcel 2010 - C:\Program Files\Microsoft Office\Office14\XlstartIf you can't find the 'Excel.exe' file in the default location, use the search feature on the Windows Start menu to search for it. Click 'OK.'
4. Add the command line to the end of the file path, outside the closed parentheses. The file command to open a specific spreadsheet is as follows:'c:\My Folder\book1.xlsx'The path inside the parentheses is the location of the spreadsheet file you want to open when Excel starts.
5. Click 'Next.' Type a name for the new shortcut. This should be something that you can associate with the spreadsheet that will open. Click 'Finish.' The new shortcut will appear on the desktop represented by the Excel icon.
6. Click the new shortcut to open Excel directly to the desired spreadsheet.

Blogger news