Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to check Pivot Table source?
Hi,
I use a file created in Excel 2003 and need to check if the Pivot table calls proper ranges. Is there any way to check what the source for the Pivot is? And, can the source range be redefined for this Pivot? I don't want to just start new pivot from scratch, as there are different formulas on that spreadsheet that uses its values. Thanks, Marcin |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to check Pivot Table source?
Hi Marcin,
I use a file created in Excel 2003 and need to check if the Pivot table calls proper ranges. Is there any way to check what the source for the Pivot is? And, can the source range be redefined for this Pivot? Select a cell in the pivot table. Then open the pivot table wizard (Data - Pivot Table and Pivot Chart Report). Click the back button. You will be in step 2 of the wizard and be able to see and change the data range. Ed Ferrero www.edferrero.com |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to check Pivot Table source?
Hi,
If you are using 2007: Select anywhere in the pivot table and choose PivotTable Tools tab, Options tab, Change Data Source. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Marcin Peciak" wrote: Hi, I use a file created in Excel 2003 and need to check if the Pivot table calls proper ranges. Is there any way to check what the source for the Pivot is? And, can the source range be redefined for this Pivot? I don't want to just start new pivot from scratch, as there are different formulas on that spreadsheet that uses its values. Thanks, Marcin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I check/verify data in my Data Source for Pivot table? | Excel Worksheet Functions | |||
Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
Transforming pivot table back to the source table | Excel Worksheet Functions | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions |