![]() ![]() Delete all slicers from everywhere on this workbook. You can now add new Slicers to the Pivot and they should not be linked to the old Pivots.Ģ. At this point, you may continue to use the new source (whereas you can link the new sourceġ:1 with old), or you can switch the Pivot back to the original source, and delete the copied replica sheet/table. Then, on the Pivot that you want to un-link, change the source to the newly created source. Then, rename the newly copied Table to something new. So, copy the sheet that has the SourceTable toĪ different sheet name. Then, Create a replica of the Source (to keep the example simple, I would assume your Pivot's source is a Table). First delete the slicers that are linked with the New Pivot that you want to be un-linked. I have quite a few slicers, and it would be a tremendous pain to recreate all my slicers for each report sheet I need to create (about 10 total)ġ. What property needs to be changed/unique between the original slicer and the copy, to allow them to independently accept the pivottable connection, and where is that property located? I even tried accessing the properties via the developer ribbon, to noĪvail. Excel treats them as the same slicer, but I need them to be treated independently. Selections on either slicer are replicated to the corresponding I change the slicerOld to pivotOld, then go to SlicerNew and change it to pivotNew, then go back to slicerOld and it is now set to pivotNew. ![]() Instead, changing the connection for a slicer still changes theĬonnection for the corresponding slicer on the other sheet. So at this point, I would think that I could go under the slicer pivottable connections, and set the ones on the old sheet to the old pivot, and the ones on the new sheet to the new pivot. ![]() I also changed the slicer names and slicer captions. The old and new worksheets have different names, and the pivottables have different names (changed on the pivottable ribbon). I now need another copy of the pivot with mostly the same (but some different) info, and many of the same slicers, so I made a copy of the worksheet (right click on worksheet, duplicate). I have a pivottable connected to an OLAP cube, and added several slicers. Ok, I'm probably missing something simple. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |