Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect large spreadsheet and email to customer.
I have a 2000 line spreadsheet with 3 columns. One column has my cost and the
last column has what I charge the customer. How can I send my customer a copy of this spreadsheet without having them see my cost. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect large spreadsheet and email to customer.
I would not take any chances and copy the columns for the customer into a new
sheet and send them that -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Dennis1188" wrote: I have a 2000 line spreadsheet with 3 columns. One column has my cost and the last column has what I charge the customer. How can I send my customer a copy of this spreadsheet without having them see my cost. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect large spreadsheet and email to customer.
As john has said, the only way to be certain is to remove your costs from the
worksheet you send completely. Even if you hid your prices and protected the worksheet and the recipient didn't crack the password (something done relatively easily) he might still be able to 'infer' your prices if the quoted prices are generated with a formula and he can see the formula. Easy way to prepare a 'secure' copy to send is to first make a copy of the workbook, then open the copy and select all of the numbers and values you want to send to him and use Edit | Copy. Then with all of those still selected, use Edit | Paste Special with the [Values] option chosen. This will convert the selected entries to their values, erasing the formulas used to generate them and you can then delete your costs from the sheet/book without ending up with a bunch of #REF or other errors. Plus you still have the original book with your costs in it. "Dennis1188" wrote: I have a 2000 line spreadsheet with 3 columns. One column has my cost and the last column has what I charge the customer. How can I send my customer a copy of this spreadsheet without having them see my cost. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONVER CSV CUSTOMER DATA TO A CUSTOM INDIVI CUSTOMER PRICE SHEET | Excel Discussion (Misc queries) | |||
Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
how do I advance filter a large csv file for unique customer #'s | Excel Worksheet Functions | |||
Spreadsheet for customer product form | Excel Discussion (Misc queries) | |||
How can I hide formulas in a spreadsheet to send to a customer? | Excel Discussion (Misc queries) |