|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 9th 06, 11:49 PM
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. 
|
| Ads |
|
#2
October 10th 06, 12:34 AM
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
October 10th 06, 05:22 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| change the ODBC data source of a pivot table | JohnH | Excel Discussion (Misc queries) | 0 | August 16th 06 07:10 PM |
| Ctrl-A for new source data in Pivot Table | KonaAl | Excel Discussion (Misc queries) | 3 | May 23rd 06 07:00 PM |
| Pivot Table data source "data source contains no visible tables" | Jane | Excel Worksheet Functions | 0 | September 29th 05 08:28 PM |
| Change Data In Pivot Table | John Calder | New Users to Excel | 1 | July 7th 05 10:41 PM |
| Pivot table, dynamic data formula | Excel GuRu | Excel Discussion (Misc queries) | 3 | May 3rd 05 10:45 PM |
Linear Mode
