PDA

View Full Version : Solved: Paste Special, Values



SherryO
11-15-2005, 01:47 PM
I have a spreadsheet that has 10 columns and 10,000 rows of formulas. I have it in a dynamic named range (=OFFSET(Source!$A$1,0,0,COUNTA(Source!$A:$A),COUNTA(Source!$1:$1))), which picks up the rows with the formulas in them, but no data as well as the data rows. I am trying to do a paste special values only to get the data that is actuall there to populate a pivot table. My problem is that after I do the paste special values, my pivot table picks up the rows that used to contain formulas as data rows, so I have a bunch of blanks and zeros in my pivot table. Can anyone tell me how to copy the formulas and only get the values for real?
Thanks

Zack Barresse
11-15-2005, 05:31 PM
Not sure how your pivot table is setup, but if you right click any Pivot Field and select Table Options, there is a checkbox for For empty cells, show. Check that and leave the box blank.

If that doesn't help, you can zip/upload a small sample file of your pivot table.