Display Pivot Data Source
long time user, first time poster.
i have a pivot table that I change the data source on weekly. All the data sources are tabs in the same workbook. I'd like to be able to display the tab name that contains the data source as a cell on my pivot table so I know which table I am pivoting without having to open the options/ change data source etc.
any help here would be much appreciated.
Re: Display Pivot Data Source
Check the Pivot Play Addin whether it solves your expectation.
You can get the Pivot Play addin by just doing a google search.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *
below to Add Reputation
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Don S in forum Excel Formulas & Functions
Last Post: 12-19-2016, 05:13 PM
By Serdica in forum Excel Charting & Pivots
Last Post: 03-10-2013, 04:19 PM
By FerdieB in forum Excel Charting & Pivots
Last Post: 09-05-2012, 03:19 AM
By Excel_pivs in forum Excel General
Last Post: 07-21-2010, 01:43 PM
By mlk in forum Excel Programming / VBA / Macros
Last Post: 05-25-2009, 11:36 AM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1