Security on spreadsheets
I have prepared a pretty advanced spreadsheet to give to a potential
customer. Because this customer does not have an exclusive agreement with my company, I would like to build in some security so they cannot see the calculations and base values. I tried to hide the sheet with the calculations and protect it. On of our sales guys was able to break this open in less than 20 minutes. How can I better secure this? |
Security on spreadsheets
The password protect ion on a workbook/worksheet is not very good there are
programs on the web as you found out the can break the password in minutes. I've done it myself on a protected sheet to find out how cells were calculated. "Jeremy" wrote: I have prepared a pretty advanced spreadsheet to give to a potential customer. Because this customer does not have an exclusive agreement with my company, I would like to build in some security so they cannot see the calculations and base values. I tried to hide the sheet with the calculations and protect it. On of our sales guys was able to break this open in less than 20 minutes. How can I better secure this? |
Security on spreadsheets
I very much agree with Joel - Excel is not very password protected and
depending on how advanced they are, it can be broken. Other than the basic Password protection on a sheet/workbook, you can use an addin and protect that also then at least they have to have another level of expertese to get into the file. This may require you sending something to have them load the macro each time. "Jeremy" wrote: I have prepared a pretty advanced spreadsheet to give to a potential customer. Because this customer does not have an exclusive agreement with my company, I would like to build in some security so they cannot see the calculations and base values. I tried to hide the sheet with the calculations and protect it. On of our sales guys was able to break this open in less than 20 minutes. How can I better secure this? |
Security on spreadsheets
Send him a PDF file of the sheet he needs to see.
Jeremy wrote: I have prepared a pretty advanced spreadsheet to give to a potential customer. Because this customer does not have an exclusive agreement with my company, I would like to build in some security so they cannot see the calculations and base values. I tried to hide the sheet with the calculations and protect it. On of our sales guys was able to break this open in less than 20 minutes. How can I better secure this? |
Security on spreadsheets
Hi Jeremy,
You can hide the calculations and send a file in PDF/Word format to the customer. They will not know what & how the calculations were performed -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "Jeremy" wrote: I have prepared a pretty advanced spreadsheet to give to a potential customer. Because this customer does not have an exclusive agreement with my company, I would like to build in some security so they cannot see the calculations and base values. I tried to hide the sheet with the calculations and protect it. On of our sales guys was able to break this open in less than 20 minutes. How can I better secure this? |
All times are GMT +1. The time now is 09:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com