Preventing "undeleting" data in Excel
 

We have an Excel (version 2002) spreadsheet that will be forwarded to an
external client. The spreadsheet contains a large number of cells with data
in a text format. Some text will need to be edited prior to sending the
spreadsheet to the client. For example a name will need to be removed from
the text of a cell, there would be about 100-200 cells per spreadsheet which
have been edited.

Example, a cell would contain the following data: "Sally red car monday", we
have edited this cell to read "red car monday". We do not want the client to
see the name "Sally". How do we ensure that the client cannot "undo" the
changes and reveal the data we had previously removed ?

Preventing "undeleting" data in Excel
 

Make your changes and save the workbook with a different name as the source
file. They will only see the current data. There will be no "undo" function.

"megsolve" wrote:

We have an Excel (version 2002) spreadsheet that will be forwarded to an
external client. The spreadsheet contains a large number of cells with data
in a text format. Some text will need to be edited prior to sending the
spreadsheet to the client. For example a name will need to be removed from
the text of a cell, there would be about 100-200 cells per spreadsheet which
have been edited.

Example, a cell would contain the following data: "Sally red car monday", we
have edited this cell to read "red car monday". We do not want the client to
see the name "Sally". How do we ensure that the client cannot "undo" the
changes and reveal the data we had previously removed ?

Preventing "undeleting" data in Excel
 

Make sure you don't turn that Tools|track changes option.

I've found that hiding rows/columns with important information is much more
dangerous. It's easy to forget to delete that stuff before sending.



megsolve wrote:

We have an Excel (version 2002) spreadsheet that will be forwarded to an
external client. The spreadsheet contains a large number of cells with data
in a text format. Some text will need to be edited prior to sending the
spreadsheet to the client. For example a name will need to be removed from
the text of a cell, there would be about 100-200 cells per spreadsheet which
have been edited.

Example, a cell would contain the following data: "Sally red car monday", we
have edited this cell to read "red car monday". We do not want the client to
see the name "Sally". How do we ensure that the client cannot "undo" the
changes and reveal the data we had previously removed ?

--

Dave Peterson