Excel 2007 / PivotTable Options / Data question

[Long Nose]

Hi All,

I am frustrated with XL 2007 pivot tables. I am unable to see "Change Source Data" on the "Data" tab under "Pivot Table Options." The help menu says it should be there, but it isn't.

These tables were created in XL 2003 and I just want to see what the pivot table is currently referencing and be able to change the source if needed.

Does anyone think they might know what the problem is?

 

[Andrew Poulsom]

Does this help you?

http://www.pivot-table.com/pivot-table/locate-the-source-data-for-a-pivot-table

 

[Long Nose]

Does this help you?

http://www.pivot-table.com/pivot-table/locate-the-source-data-for-a-pivot-table

Thanks! Yes it does.

eeek! My error was right clicking on the table itself, selecting PivotTable Options and clicking Data, not there. But it is under the "ribbon" Options / Data.