Jump to content


JPL

Member Since 10 Sep 2008
Offline Last Active May 05 2017 04:14 PM
-----

Topics I've Started

Excell Pivot Table Source

28 April 2017 - 10:35 AM

Hello, quick question regarding Excell pivot tables and source data. I have a pivot table on one spreadsheet and multiple spreadsheets containing the source date.

I have used the following =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1))) which gives me the tab name of the spreadsheet the pivot table is on.

But is there a way that in another cell it's able to show the name of the spreadsheet the source data is on; and change as I switch between source data spreadsheets?