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