If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 ? |
#2
|
|||
|
|||
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 ? |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|