Pivot Table - Linked to Access

reemoe

New Member
Joined
Oct 24, 2005
Messages
41
I have an existing pivot table in Excel that uses Access as the source data. I've made some changes to the Access table. What is the easiest way to update the Excel pivot table to take in account these changes?

And will my pages that I created using "Show Pages" from the pivot table be immediately updated with these changes, as well?

Thanks!
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Watch MrExcel Video

Forum statistics

Threads
1,118,069
Messages
5,570,008
Members
412,304
Latest member
citrus
Top