LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ellen
 
Posts: n/a
Default updating pivot table to include additional rows

Tried Refresh Table to update the pivot table. My experience with the
Refresh Table will update the values in the data that I've used to create the
pivot table with. My issues is adding additional rows to the data and having
these new rows added to the pivot table. for example, creating a pivot table
asks the range of cells to create the table with, A1-G343. If I add rows
A344-G454, these are not included in the data. I'd like all rows A1-G454
included in the pivot table without redefining the pivot table.

Is it possible to do this?
 
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
Pivot Table - max rows allowed in data range dmotika Excel Discussion (Misc queries) 2 May 26th 05 05:52 PM
Pivot Table for survey data w/ questions as Rows & poss answrs as pfwebadmin Excel Discussion (Misc queries) 0 May 17th 05 02:31 PM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 07:24 PM
Have a Pivot Table Include a "% of an item" [email protected] Excel Worksheet Functions 1 February 23rd 05 10:32 PM
How do I manipulate pivot table report to include percentage of? KRUEMJ-Needs some help Excel Discussion (Misc queries) 2 January 31st 05 01:06 AM


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

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

About Us

"It's about Microsoft Excel"