-
Solved: Paste Special, Values
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
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules