Home > Articles > Home & Office Computing

This chapter is from the book

Storing Document Details

The Windows file system keeps track of details about each file: its size, when it was created, and when you last modified it, for example. Windows enables you to store extra details about Office file types; these properties include the author's name, a title and a subject for the file, and comments or keywords that you can use to search for documents later. A Custom properties sheet lets you track more than two dozen built-in categories or add your own.

Maintaining file properties takes a fair amount of up-front work, but it can have a profound pay-off, especially in a networked office where many users share documents.

  • When you use the Advanced File Search task pane, you can search for any property of any Office file. If you've trained an entire department to enter details about a client, project, or product line in the Properties dialog box (or if you've automated this process with macros), it's trivially easy to locate all the files associated with that activity.

  • In Windows Explorer's Details view, you can add columns for many Office file properties. For instance, in a folder filled with Word documents, right-click any column heading to display a list of available columns, and then click Title and Author to add those fields to the display.

  • All file properties are available to macros that you create by using Visual Basic for Applications. As a result, you can create simple but effective document-management routines that are limited only by your imagination. For example, you can create AutoNew macros that prompt users for key information every time they create a new document based on a particular Word template. You can then use that information to file or route the document when the user saves it.

    For more ideas and techniques using VBA, see Chapter 43, "Building Custom Applications with VBA."

To view and edit the properties of a file currently open in an Office program, choose File, Properties. The dialog box that appears resembles the one in Figure 3.5.

The Properties dialog box for an Office file includes the five tabs described in Table 3.1.

Figure 3.5 The Properties dialog box displays summary information about Office file types.

Table 3.1 Office File Properties

Properties

Description

General

Basic information from the Windows file system: name, location, size, and so on.

Summary

Information about the current file and its author, including fields for company name, category, and keywords. The Comments field is particularly useful when you use Outlook's file management capabilities because the text appears beneath each filename when you turn on AutoPreview.

Statistics

Details about the size and structure of the file, such as the number of words in a document or the number of slides in a presentation; also displays revision statistics and total editing time. This tab is not visible when inspecting file properties from within Windows Explorer; instead, the information is displayed on the Summary tab. This information is frequently incorrect, especially when you inspect it from within an Explorer window. Professional writers and students who rely on these statistics should always inspect them from within the document itself to guarantee that the information is up-to-date.

Contents

The parts of the file: the outline of a Word document, based on heading styles; worksheet titles in an Excel workbook; or slide titles in a PowerPoint presentation. This tab is not visible when inspecting file properties from within Windows Explorer.

Custom

Twenty-seven built-in fields that you can choose from, including Client, Document Number, and Date Completed. Alternatively, you can add a field of your own. Custom fields can contain text, dates, numbers, or Yes/No information; they can also be linked to Word bookmarks, named Excel ranges, or PowerPoint text selections.


NOTE

You can inspect most Office file properties by right-clicking a filename in Windows Explorer and choosing Properties from the shortcut menu. Information in this dialog box is arranged differently from what you see within an Office program, and many properties are not available when the file is open for editing. For data files located on a disk formatted with the NTFS file system, you'll see an additional tab that contains security settings.

For simple projects, you might choose to ignore file properties; in these cases, a descriptive filename can tell you everything you need to know about the file. For more complicated documents, however, adding file details—including keywords and categories—can help you or a co-worker quickly find a group of related data files, even months or years after you last worked with them. Use the Comments box to add freeform notes about a given file.

To enter additional details about an Office file, you must open the Properties dialog box before you save the file. If you use this feature regularly, you can configure Word, Excel, and PowerPoint to display the File Properties dialog box every time you save a file.

To learn more about the common features found within the Office applications, see "Configuring Common Office Features."

Default Document Properties

By default, Office applications save only a few document properties when you save a file. Properties saved vary by application:

  • Windows stores standard file details, including the name, size, and date and time the file was modified.

  • All Office applications add your name and your organization's name (or whatever name you specify on the User Information tab of the Options dialog box for that program) in the Author and Company fields, respectively.

  • Word and PowerPoint fill in the Title field as well, using the first few words of a Word document or the title of a PowerPoint presentation.

NOTE

In Word documents in particular, this capability can lead to embarrassing consequences if you're not careful. By default, if you fail to enter document properties, Word picks up the opening line of your document and plops it in the Title field—up to the first paragraph mark or 126 characters, whichever comes first. For example, if you begin composing an angry memo and save it, your initial angry words might survive in the Title field, even if you tone down your rhetoric considerably in the final version. That fact alone is an excellent reason to configure Word to pop up the Properties dialog box whenever you save a new document.

If you want to add categories, keywords, or comments to any Office file, do so on the Summary tab.

Using Custom Properties to Organize Files

In an office where a large number of people create and share files, custom file properties can make it easier for workgroups to share files. In a legal office, for example, you might use the Client, Status, and Recorded Date fields to track the progress of Word documents. Members of a team producing budget worksheets might use the Checked By and Forward To fields as part of a document management system. Use the Office applications' Search task panes to find files whose properties match a particular set of criteria. Figure 3.6 shows a Word document that includes several custom properties.

Figure 3.6Figure 3.6 Record additional file properties on the Custom tab; later, use the Find tool in Office common dialog boxes to search for files that match these criteria.

To enter custom criteria for any Office file, follow these steps:

  1. Open the file and choose File, Properties.

  2. Click the Custom tab to display the dialog box shown previously in Figure 3.6.

  3. Choose a field from the Name list. To create a new field, type its name here.

  4. Choose one of the available data types from the Type drop-down list.

  5. Type the data for the selected field in the Value text box.

  6. CAUTION

    If you specify Number or Date as the data type for a custom field, you must enter the value in a matching format. If you enter dates in a nonstandard format or you include text in a field that should contain only numbers, Office enters the value as text.

  7. Click Add. The new entry appears in the Properties list at the bottom of the dialog box.

  8. Repeat steps 3–6 for any additional custom fields. To remove an item from the Properties list, select its entry and click Delete. Click OK to close the dialog box and return to the program window.

The Link to Content check box is grayed out and unavailable unless you're working with a Word document that contains bookmarks, an Excel workbook that contains named ranges, or a PowerPoint presentation containing linked text. In any of those cases, you can enter a custom field name, select the Link to Content check box, and then choose the bookmark or named range. In a PowerPoint presentation, you must select the text you want to link to a custom field before opening the Properties dialog box.

Using Windows Explorer to View File Properties

To view any Office file's properties without opening the file itself, open a Windows Explorer window, right-click the file's icon, and then choose Properties. In most Windows versions, you can edit most file properties for Word documents, Excel workbooks, Publisher publications, and PowerPoint presentations directly from an Explorer window. Regardless of which Windows version you use, only the most basic summary information is available when you view the properties of an Access database from an Explorer window.

In Windows XP, you can see some Office file properties, such as the author's name, in the info pane along the left side of a Windows Explorer window, as shown in Figure 3.7. You can also see a thumbnail of the file itself in this region, but only if you selected the Save Preview Picture check box on the Summary tab of the Properties dialog box. By default, this check box is cleared for Word documents and Excel workbooks and is selected for PowerPoint presentations.

Figure 3.7Figure 3.7 In Windows XP, you can view some information drawn from an Office file's properties from within Windows Explorer. The thumbnail preview is available only if you check an option when saving the file.

To save a preview of an Excel workbook, you must check this box when you first save the file; see "No Preview in Common Dialog Boxes" in the "Troubleshooting" section at the end of this chapter for more details.

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.

Overview


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information


To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.

Surveys

Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.

Newsletters

If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information


Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.

Security


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.

Children


This site is not directed to children under the age of 13.

Marketing


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information


If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.

Choice/Opt-out


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information


Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents


California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure


Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.

Links


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact


Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice


We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020