Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Increasing the Source Data range for an existing Pivot Table
Folks,
I had already created a pivot table with a set number of rows. However, I have added extra rows to the original data. I know that if I had created a dynamic range then the pivot table would be able to automatically refresh the data range. However, is there another way of getting around this issue. Can I just go to Pivot table wizard and select the new range (this might ask me to recreate the Pivot table). What else can I do to increase my data range while keeping the same Pivot worksheet? Thanks for your help. Shams. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Increasing the Source Data range for an existing Pivot Table
Shams,
If you're using Excel 2003, you can define a list (Data|List|Create List...), this will allow entries to go at the bottom of the list and you will be able to refresh the pivot table to include the new data. -- Hope this helps, MarkN "Shams" wrote: Folks, I had already created a pivot table with a set number of rows. However, I have added extra rows to the original data. I know that if I had created a dynamic range then the pivot table would be able to automatically refresh the data range. However, is there another way of getting around this issue. Can I just go to Pivot table wizard and select the new range (this might ask me to recreate the Pivot table). What else can I do to increase my data range while keeping the same Pivot worksheet? Thanks for your help. Shams. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Increasing the Source Data range for an existing Pivot Table
Yes, you can update the source data.
1. Right-click inside the pivot table; select PivotTable Wizard 2. Click the Back button 3. Update the range as needed 4. Click the Finish button "Shams" wrote in message ... Folks, I had already created a pivot table with a set number of rows. However, I have added extra rows to the original data. I know that if I had created a dynamic range then the pivot table would be able to automatically refresh the data range. However, is there another way of getting around this issue. Can I just go to Pivot table wizard and select the new range (this might ask me to recreate the Pivot table). What else can I do to increase my data range while keeping the same Pivot worksheet? Thanks for your help. Shams. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change the ODBC data source of a pivot table | Excel Discussion (Misc queries) | |||
Ctrl-A for new source data in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) |