Saving useful information in your workbooks using workbook properties is extremely useful especially when you are trying to find a particular workbook. Properties - Lists all the custom properties that have been created in the active presentation.Īdd - Adds the custom property to the active presentation.ĭelete - Removes the custom property from the active presentation. Link to content - Whether the custom property is linked to a specific item in the file. Value - The text or value you want to save as the custom property. Type - The type of the property, either Text, Date, Numeric or Yes / No. Name - Select or create a name for the property. It is possible to add your own custom properties and it is even possible to link these to cells. Last saved by - The user name of the person who last saved this workbook. Modified - The date the workbook was last modified.Īccessed - The date the workbook was last accessed. This is not a particularly user friendly options and selecting this will increases the size of the file.Ĭreated - The date the workbook was created. Save preview picture - Saves a picture of the first page of the file for previewing in the New dialog box. This can be an Internet address, a path to a folder on your hard disk, or a path to a folder on a network. Hyperlink base - Type the path or URL that you want to use for all hyperlinks with the same base address that are inserted in the current document. The other properties can be used to group similar files together, so you can search for files that have specific properties. Use this property to group similar files together, so you can search for all files that have the same subject. The title can be different from the file name. Title - Type the title you want to use when searching for this file. Location - The folder location of the Excel workbook. This is always Microsoft Excel Worksheet. These properties can be extremely useful when you are searching for files. It is possible to add useful information to an active workbook such as the author, title or additional comments. You can associate an enormous range of information with an individual workbook (File > Properties). This can be very useful when you have to manage a large number of files. You can use this information to then search for specific files.
0 kommentar(er)
