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" ...
Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 File Management and Recovery - Remember to Save Workbook Properties.
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.