Julie,

After you paste special to values, paste special again to do column widths,
and again to do formatting. These are all options in paste special

"Julie" wrote:

Ken,
I responded too quickly this morning to your answer. The problem with doing
what you suggest, is what I referred to in my original question. Paste
special as values does break the link, but it requires re-formatting the
report completely. This report will be done too often to do that each time.
I have to go in and adjust column widths, fonts of various sizes, color fills
and text orientation.

What finally worked is to paste special as format. This creates the report
format with no numbers. Then I did another paste special, this time as
values, and it dropped my data into the format I had just created! Too bad
there isn't an option for "paste special - values and format"

Thanks for leading me in the right direction.

Julie


"Ken Wright" wrote:

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