Pivot tables / source data - Please help

[tgsmc611]

Is there a way to take a pivot table and copy and paste it into a new
document so that the source data cannot be pulled up by the person
looking at it? The reason I need to do this is because I have created
a pivot table and included in the source data is very confidential
information. I want to be able to send out JUST the actual pivot
table, but I don't know how to do this without releasing all of the
other information along with it. Is this even possible??

 

[Pete_UK]

Have you tried doing <copy> (on the table), then moving the cursor to
another sheet and Edit | Paste Special | Values (check) | OK then
<Esc>?

This will fix your values on the other sheet, then you can remove the
other sheets so that the Users will not be able to see the source
data.

Hope this helps.

Pete

 

[tgsmc611]

Have you tried doing <copy> (on the table), then moving the cursor to
another sheet and Edit | Paste Special | Values (check) | OK then
<Esc>?

This will fix your values on the other sheet, then you can remove the
other sheets so that the Users will not be able to see the source
data.

Hope this helps.

Pete



- Show quoted text -

Yes - I have tried that. However, when I do this it changes the way
the pivot table looks - it actually look sreally bad when I do it this
way. It doesn't even look like a pivot table anymore!

 

[Pete_UK]

You can always follow this bit:

Edit | Paste Special | Values (check) | OK

with this:

Edit | Paste Special | Formats (check) | OK

before doing <Esc> to make it look more like the original, and then
adjust column widths etc.

Obviously, there will be no interaction with the source data, so it
will not act exactly like a pivot table anymore.

Pete

 

[Alan]

Create another pivot table the same as the original. Open a new workbook,
cut and paste the new table into the new workbook and save it. This pivot
table will be linked to the original file. When the user opens the pivot
table workbook, they will receive a message asking to update the pivot table
data. Have the user select yes to refresh the data.

Regards,

Alan

 

[Kevin Labore]

One way you could do this is to use a PDF Creator (there are Free ones like
PRIMO)
you then could print to the PDF print driver and send the PDF file as an
attachment
This works quite well for myself as I do this. The PDF is much normally
smaller than the Workbook or worksheet especially with a large data cache.

HTH
Kevin

 

[ilia]

Start highlighting the pivot table from the last row. Do not
highlight the topmost row. Use standard copy/paste. You should be
able to retain all formats and text.

You can also do a "copy as image", which is what the book Excel Hacks
suggests.