| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Source Worksheet and Range
Is there a way to view in a pivot table sheet which of the other worksheets
in a workbook it derived from, and what was its original range within that raw data worksheet? -- Rene - Do appreciate your help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Source Worksheet and Range
In Excel 2003, and earlier versions, right-click a cell in the pivot
table, and click PivotTable Wizard. Click Back, and you'll see the range address or name. In most cases, the range will be activated on the worksheet in the background. Rene wrote: Is there a way to view in a pivot table sheet which of the other worksheets in a workbook it derived from, and what was its original range within that raw data worksheet? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Source Worksheet and Range
Nice and simple. Excellent! Thank you so much!
-- Rene - Do appreciate your help "Debra Dalgleish" wrote: In Excel 2003, and earlier versions, right-click a cell in the pivot table, and click PivotTable Wizard. Click Back, and you'll see the range address or name. In most cases, the range will be activated on the worksheet in the background. Rene wrote: Is there a way to view in a pivot table sheet which of the other worksheets in a workbook it derived from, and what was its original range within that raw data worksheet? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
| Increasing the Source Data range for an existing Pivot Table | Excel Worksheet Functions | |||
| 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 | |||
Linear Mode
