What's the purpose of document properties

Chicago48

New Member
Joined
Apr 25, 2009
Messages
5
I teach Office 2007/2010 and I cannot for the life of me understand the purpose of document properties. Is this a collaborative feature? And you use it in practicality?
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
its useful for "File Search" by property.
property features like "Project", or "User" and "keywords".
 
Each Document Property is unique for the file that holds it. Apart from searching you can use properties to store database passwords, for mail merges, and if you use the cover pages that come in the Quick Parts section of Word 2007/2010, the headings on those cover pages use document properties.

I used to ignore them for every application except Project and Visio; still don't use them all the time, but they do have their uses.

Denis
 
I must admit, whenever I register a microsoft product, I register as "User" at "Home" just so my personal details are excluded from the document properties. It doesn’t affect getting the updates for the product.
Ok I know they can be changed afterwards but I'm paranoid ... in a nice sort of way.

If you now find yourself checking a recent file you generated to see what personal info you just sent someone, then you are mildly paranoid too, ..... also in a nice sort of way.

As far as searching for files using the file properties, although it’s useful it's just as easy to search for a word contained in the file because I know that nobody ever uses/fills-in the properties information.
.
 
Like you, I don't tend to fill in the standard properties. Life's too short.
However:
1. In 2010 (and I think 2007) you can strip identifying information from documents before distributing them and
2. As I said, there are some useful things that you can do with doc properties in code. I mainly use them for automating merges to Word templates from Access.

Denis
 
I've used them for tagging workbooks that should be monitored by a particular add-in before.
 
One possible use:

If you work for a large organisation (and assuming your programming skills aren't up solving the problem), you should get into the habit of opening and saving a blank version of each of the major document types every day. Store them in a directory called "audit proofing'.

Then, if you ever need to generate a "missing" document that you really should have produced some time in the past, you can simply go back to the doc for that day and start from there. The document properties will demonstrate to the naive auditor that the document was indeed created on the day you said it was and potential audit problem avoided / **** covered :)
 

Forum statistics

Threads
1,222,630
Messages
6,167,191
Members
452,104
Latest member
jadethejade

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top