LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Adding to an existing Pivot Table

If I have created a pivot table and later add more rows of data to the main
sheet (which the pivot table was created from), is there a way to update the
pivot table (change the range of cells that the pivot table is referring to
so that the pivot table now includes the new rows of data)?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create pivot table from existing pivot table in excel 2007 Udayraj Dhulekar Excel Discussion (Misc queries) 2 July 8th 13 08:22 PM
Creating pivot table to Existing worksheet Malvaro Excel Worksheet Functions 1 August 29th 08 02:32 PM
adding a pivot table to an existing worksheet- HELP!! mercedes Excel Discussion (Misc queries) 1 December 21st 06 12:11 AM
Increasing the Source Data range for an existing Pivot Table Shams Excel Worksheet Functions 2 October 10th 06 05:22 PM
CELL RANGE SELECTION ON EXISTING PIVOT TABLE MitchP Excel Worksheet Functions 3 August 8th 05 08:45 PM


All times are GMT +1. The time now is 10:44 AM.

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

About Us

"It's about Microsoft Excel"