Copy the sheet by right clicking on the tab and choosing 'move or copy' and
copy to new book. Then select the entire sheet and copy and paste special
as values and it will break the link.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Julie" wrote in message
...
I have a pivot table that I update each day so that Management can see our
daily order status. Once a month I want to present a portion of that
table
to a customer, (his particular orders). I don't want the customer to be
able
to pivot the table and see orders other than his. I know I can copy and
past
the data into a new worksheet, but that will require doing some
re-formatting
each time to adjust column widths, etc.
Once I've copied the sheet pivoted to that customer's information to a new
workbook, how do I keep him from performing the pivot?

--
Julie