Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot Table Help
Hi All
Is there any way that I can change the source data range after the pivot table has been created, without having to do a new sheet. I.e. Curent range is A1:D25 Want to amend to A1: F1000 Cheers Paul T |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot Table Help
1.. Right-click a cell in the pivot table
2.. Choose PivotTable Wizard 3.. Click the Back button, and select the new range 4.. Click Finish. "PJ" wrote in message ... Hi All Is there any way that I can change the source data range after the pivot table has been created, without having to do a new sheet. I.e. Curent range is A1:D25 Want to amend to A1: F1000 Cheers Paul T |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions |