Summary: Have Microsoft Excel 2003 always prompt you to save workbook properties such as title, subject, and author.
After opening a spreadsheet in Microsoft Excel 2003, if you choose "File" - "Properties", a dialog box with "Summary" and "Custom" tabs, among others, appears with document property information. This can include a workbook (spreadsheet) title, subject, author, manager, category, keywords, comments, and more.
Depending on your company or organizational needs, you may wish to enter summary and custom information to keep track of your documents. However, when creating spreadsheets, it is easy to forget adding this information into the document properties. To help remind you to do so, you can have Excel 2003 automatically query you for document properties upon save.
1. Click "Tools" - "Options".
2. When the "Options" multi-tabbed dialog box appears, click the "General" tab.
3. Check "Prompt for workbook properties".
4. Click "OK" to close the dialog box.
Yes, this probably should have been put under the "Save" tab instead of "General" ...
Add: Del.icio.us | Digg | Furl | My Yahoo!
Last Modified on: July 13, 2008, at 3:23 P.M. EDT
Return to the Microsoft Excel 2003 File Management and Recovery page.
Search the Site: