Hi all,
I have 5 pivot tables which feeds data from a single worksheet. The data from this sheet change every month. Meaning, old data out (deleted) and new one's inn.
The problem I have is the old data I used in the Row Label (such as Customer Name) are still showing in all the pivot tables even though the record is no longer there.
Has anyone had this before? If so, please kindly share your solution.
Thank you in advance.
Found this old post with the answer
http://www.excelforum.com/excel-gene...ot-tables.html
I have this problem in Excel 2010, but the url given in the reply above is incomplete and so I can't get to it.
I clicked on the URL and it went through. Click here
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks