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 |
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 |
All times are GMT +1. The time now is 07:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com