| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Checking data range in Pivot
Hi,
How do I re-check or modify the data range that a pivot is referring to? Thanks Stilla |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Checking data range in Pivot
With your cursor in the body of the pivot table, open the pivot table wizard,
then click the "back" button. That will show you the data range used to create the pivot table. "Stilla" wrote: Hi, How do I re-check or modify the data range that a pivot is referring to? Thanks Stilla |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Checking data range in Pivot
WOW! SO simple... I would have never thought of it . THANK YOU!!!
"simmerdown" wrote: With your cursor in the body of the pivot table, open the pivot table wizard, then click the "back" button. That will show you the data range used to create the pivot table. "Stilla" wrote: Hi, How do I re-check or modify the data range that a pivot is referring to? Thanks Stilla |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can you sum the last 5 columns of data from a range of data | New Users to Excel | |||
| pivot table - New Data | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Hybrid Mode
