Sharing investing and trading ideas. Helping traders get started.
Advertisement

Friday, June 19, 2009

Removing Metadata in your Excel Workbooks: Maintaining your privacy

Metadata is loosely defined as ‘data in data’. According to Microsoft Knowledge Base, metadata that is saved in your workbook includes the following

Your name
Your initials
Your company or organization name
The name of your computer
The name of the network server or hard disk where you saved the workbook
Other file properties and summary information
Non-visible portions of embedded OLE objects
Document revisions
Hidden text or cells
Personalized views
Comments

This metadata might reveal unintended information which can be used against you. Hence, I decided to write on this topic even though it has nothing to do with VBA. You can view some of this information by right clicking on any file in windows explorer, select Properties>> (the) Summary (tab)>> Advanced.

Excel 2007 makes it easy to remove these information with the Document Inspector which you can access from Office Button>> Prepare>> Inspect Document. You can select the Properties option instead to see what information you are currently showing on your document.

The only information that you cannot edit from the Document Inspector is data on when you create, modify or access the file, which you can view from Office Button>> Prepare>> Properties>> Statistics. You can work around it by tweaking with your computer clock and saving the document as a new file.

For Excel 2003 and before:
How to minimize metadata in Microsoft Excel workbooks

For Excel 2007:
Removing data and personal information for office documents

View or change the properties for an office document




Like what you have just read? Digg it or Tip'd it.
The objective of Finance4Traders is to help traders get started by bringing them unbiased research and ideas. Since late 2005, I have been developing trading strategies on a personal basis. Not all of these models are suitable for me, but other investors or traders might find them useful. After all, people have different investment/trading goals and habits. Thus, Finance4Traders becomes a convenient platform to disseminate my work...(Read more about Finance4Traders)

1 comments:

Alex said...

Some times I had quite big problems with MS Excel files, but one day I solved out such issue with the aid of one utility. I dug up it from a soft blog. It surprised me a lot and moreover I suppose the program is one the best decisions for resolving like issues as well - recovering Excel file uable to read file.

Post a Comment