Forum Discussion
Referencing the data source for a pivot table
Hi, I'm developing our annual expenses workbook to make it easier to copy and set up for a new year. Can anyone help me as to how I can reference the data area for a series of pivot table to be ...
ExcelExciting Thank you for your reply Faraz and also for replying so quickly. That's an interesting idea, but can a slicer be used to determine the data for multiple pivot tables. There are 9 pivot tables on each monthly sheet already to cut the month's data up for accounting entries and to keep running totals on the different types of mileage expenses.
Kind regards
Rob
Hi RobMacUK
Yes you can connect one slicer to multiple Pivot Tables. Add the slicer > right click > report connections. Select Pivot Need to be connected to the slicer
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com