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?