How can I change the source data in a pivot report? For example, I pulled form a table in excel that I expected to e 3,000 rows. Turns out as it kept growing it topped 4,000. I only know how to delete the table and recreate.
Is there a way to modify the source data without deleting in 2003? I know you can in 2007 but I can't use 2007 at work.
thanks
Click in your pivot table then right click (mouse) choose wizard choose back and then modify your range accordingly and then choose finish. The pivot table should be updated.
Denis
Please always attach the sample workbook without sensitive information when asking for help
To add a module
Press Alt + F11 (this is the Visual Basic Environment)
Insert Menu, select Module
Past code there
Close Visual Basic Environment (X)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks