ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table range source area reference (https://www.excelbanter.com/excel-discussion-misc-queries/206245-pivot-table-range-source-area-reference.html)

Simon[_2_]

Pivot Table range source area reference
 
Hi,

Where/How can I see where my Pivot Table data is referencing?

I am using Excel 2003.

Thanks

Barb Reinhardt

Pivot Table range source area reference
 
This is from memory, so I hope it works for you.

From the Pivot table, activate the Pivot table wizard and select BACK. It
should show the source range there.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Simon" wrote:

Hi,

Where/How can I see where my Pivot Table data is referencing?

I am using Excel 2003.

Thanks



All times are GMT +1. The time now is 03:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com