pasting values from pivot table still linked

C

ChrisC

I have a fairly big table that provides values for a pivot table. I would
like to view the data from the pivot table and copy and paste this
information to a new tab as values, and retain the formatting. The goal is
to keep the spreadsheet from freezing - which it seems to do too much. I
understand that pivot tables share cached memory.

This copy, paste special, values and paste special "all using source theme"
method seemed to be working. However, I noticed tha the sheet was freezing
more and more and today, I noticed that when I updated the pivot table for
the specific copied and pasted range, that new table of "values" also
updated!

WHen I click on an individual cell in the new tab that should have values, I
only see values.

Please help me understand what I am doing incorrectly!

Thanks,

Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table cell values 1
Dealing with a Pivot Table (when I don't want to) 0
Doughnut Chart linked with the slicer in the pivot table 0
Formula to Look up values from a pivot table 1
Additional columns for Pivot table 0
Pivot table put multiple "Values" in one row but I want them in one column. 0
Pivot table format on paste values 0
VB Script reference cells for in current table? 1

Top