LinkBack URL
About LinkBacks
I copied a worksheet with a pivot table as a new worksheet. I wanted to group each pivot table differently on each worksheet, but the changes I make on one worksheet is reflected on the other. Is there a way to break the "link" between these tables?
I copied a worksheet with a pivot table as a new worksheet. I wanted to group each pivot table differently on each worksheet, but the changes I make on one worksheet is reflected on the other. Is there a way to break the "link" between these tables?
Hi,
In what way are the tables linked?
Are you saying that you're making changes to the original data on which the Pivot tables are based, or changes to a Pivot Table
I don't see the behaviour you describe. A change in layout of one pivot table is independent of the layout of the other table even though both use the same source data.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you for responding!
When I use the grouping feature on one worksheet, it automatically groups the data on my second worksheet. For some reason, the change in layout is NOT independent on the second pivot table. Am I missing a checkbox that should be checked/unchecked in settings?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks