Hi,
I have a worksheet ("Pivotsheet") with a pivot table. In need of creating normal charts I am currently copying the entire sheet, and pasting special with values into another worksheet ("Valuesheet"). I cant use formulas, due to file size.
Can someone assist me in writing a macro that does this procedure for me, so I wont have to copy/paste everytime the pivot-table is updated?
Cheers
Gnoke
Found a way around it;
I created a history sheet where I pasted the pivot statistics, values only.
For new values in the pivot table, I simply created =ref formulas in the history sheet, and copied them down like 200 rows and hid zero values.
After a while I will modify the newly added rows in my history sheet, removing the formulas and replacing them with the values they show.
Probably not efficient for advanced users, but it works for me
Gnoke
Bookmarks