A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Increasing the Source Data range for an existing Pivot Table



 
 
Thread Tools Display Modes
  #1  
Old October 9th 06, 11:49 PM posted to microsoft.public.excel.worksheet.functions
Shams
external usenet poster
 
Posts: 47
Default 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  
Old October 10th 06, 12:34 AM posted to microsoft.public.excel.worksheet.functions
MarkN
external usenet poster
 
Posts: 104
Default 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  
Old October 10th 06, 05:22 PM posted to microsoft.public.excel.worksheet.functions
M. Authement
external usenet poster
 
Posts: 94
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 09:40 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.