I hope I'm asking the right question.
Is there a way to link the data from your original pivot table to each of the tabs created?
I have a pivot table with 20 departments that need to be on separate tabs (20 tabs). I would like to link the original table to all the tabs created so I would only have to update 1 original tab and the other tabs would then update automatically with new data.
thank you for any information that may help me.
have a wonderful day!!!
Here is an article about Show Report Filter Pages: https://www.excelcampus.com/pivot-ta....%20See%20More.
Scrolling down to the "Important Things to Note" section it says: "When we make changes to the original pivot table, those changes will NOT be reflected in the new filter pages pivot tables. If we wanted to change the layout or formatting of all the reports, it would be best to delete all the filter pages (new worksheets) and generate the reports again."
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks