Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot table does not automatically update when underlying data cha
Excel 2007, Vista
How can I make the pivot table update automatically when the underlyng data changes? (F9 doesn't force an update.) Also, how can I add more data to be included in an existing pivot table wihout creating a new one? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot table does not automatically update when underlying data cha
How can I make the pivot table update automatically when the underlyng data
changes? (F9 doesn't force an update.) Think that has been the behaviour all along In xl 2003, just right-click anywhere within the pivot Refresh Data And you can always record a macro specific to your pivot if you think that right-click step isn't simple enough (it is to me) .. how can I add more data to be included in an existing pivot table without creating a new one? You add data to the pivot's underlying source. Then you extend the pivot's source range by right-clicking anywhere within the pivot Pivot table wizard Back (to go back to Step 2 of the wizard). Manually edit the range Finish. Debra Dalgleish has great stuff on how you can make it dynamic for pivot data sources: http://www.contextures.com/xlPivot01.html Excel -- Pivot Tables -- Dynamic Data Source -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "PFB" wrote: Excel 2007, Vista How can I make the pivot table update automatically when the underlyng data changes? (F9 doesn't force an update.) Also, how can I add more data to be included in an existing pivot table without creating a new one? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot table does not automatically update when underlying data
Thanks. The reference was very helpful. Also, in Excel2007 the whole
workbook (including the pivot tables) can be refreshed using <Ctrl <Alt F5. "Max" wrote: How can I make the pivot table update automatically when the underlyng data changes? (F9 doesn't force an update.) Think that has been the behaviour all along In xl 2003, just right-click anywhere within the pivot Refresh Data And you can always record a macro specific to your pivot if you think that right-click step isn't simple enough (it is to me) .. how can I add more data to be included in an existing pivot table without creating a new one? You add data to the pivot's underlying source. Then you extend the pivot's source range by right-clicking anywhere within the pivot Pivot table wizard Back (to go back to Step 2 of the wizard). Manually edit the range Finish. Debra Dalgleish has great stuff on how you can make it dynamic for pivot data sources: http://www.contextures.com/xlPivot01.html Excel -- Pivot Tables -- Dynamic Data Source -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "PFB" wrote: Excel 2007, Vista How can I make the pivot table update automatically when the underlyng data changes? (F9 doesn't force an update.) Also, how can I add more data to be included in an existing pivot table without creating a new one? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot table does not automatically update when underlying data
Hi,
Question 1: Ctrl+Alt+F5 does not refresh the whole workbook. In 2007 press Alt+F5 to refresh the active pivot table and Ctrl+Alt+F5 to refresh all pivot tables and external data connections. Refresh command can be found under Data, Refresh All or PivotTable Tools, Options, Refresh as well as by right-clicking anywhere in the pivot table and choose Refresh from the shortcut menu. Question 2: Yes! The best way to handle this is to define the data area as a table, (Home, Format as Table), then the pivot table will automatically know when new data has been added to the data area. You will still need to refresh the pivot table. If this helps, please click the Yes button. Cheers, Shane Devenshire "PFB" wrote: Thanks. The reference was very helpful. Also, in Excel2007 the whole workbook (including the pivot tables) can be refreshed using <Ctrl <Alt F5. "Max" wrote: How can I make the pivot table update automatically when the underlyng data changes? (F9 doesn't force an update.) Think that has been the behaviour all along In xl 2003, just right-click anywhere within the pivot Refresh Data And you can always record a macro specific to your pivot if you think that right-click step isn't simple enough (it is to me) .. how can I add more data to be included in an existing pivot table without creating a new one? You add data to the pivot's underlying source. Then you extend the pivot's source range by right-clicking anywhere within the pivot Pivot table wizard Back (to go back to Step 2 of the wizard). Manually edit the range Finish. Debra Dalgleish has great stuff on how you can make it dynamic for pivot data sources: http://www.contextures.com/xlPivot01.html Excel -- Pivot Tables -- Dynamic Data Source -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "PFB" wrote: Excel 2007, Vista How can I make the pivot table update automatically when the underlyng data changes? (F9 doesn't force an update.) Also, how can I add more data to be included in an existing pivot table without creating a new one? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can you tell if your data set has been setup as atable?
I have a file with a data source and a few pivot tables based on it. I want to have all of the pivot tables refresh when the data is refreshed. How can you determine if the data has been setup as a table so that everything gets updated at the same time?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
Pivot Table Data did not update | Excel Worksheet Functions | |||
Displaying pivot cell underlying data | Excel Discussion (Misc queries) | |||
update the underlying data source of a pivot table | Excel Discussion (Misc queries) | |||
Why doesn't my chart update when underlying data changes? | Charts and Charting in Excel |