Pivot Tables / Linking Worksheets
Hi,
Can anyone out there tell me how I can link data between sheets so my sheet w/ the pivot table is updated everytime my master is changed? I'm very green w/ pivot tables so please dumb it down :) Thanks!! P@ty |
Pivot Tables / Linking Worksheets
Pivot tables are linked to their source data.
However, they have to be refreshed manually rather than like formulas. You can use VBA to refresh the table, so you could use one of the Excel events to detect the actions that would warrant refreshing the table. (put code to refresh the table in that event) See Chip Pearson's page on events if you are not familiar: http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "p@ty" wrote: Hi, Can anyone out there tell me how I can link data between sheets so my sheet w/ the pivot table is updated everytime my master is changed? I'm very green w/ pivot tables so please dumb it down :) Thanks!! P@ty |
All times are GMT +1. The time now is 02:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com