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.

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.

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.