Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 File Management and Recovery

Remember to Save Workbook Properties

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.

Print this tip.

- Subscribe!

Search the Site: