| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 |
| 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 | |||
![Ed Ferrero[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
