A Alley Cat Aug 26, 2008 #1 I am working in Excel 2007 and when I update my source data, charts in other sheets do not get updated.
I am working in Excel 2007 and when I update my source data, charts in other sheets do not get updated.
V venumadhav g Aug 27, 2008 #2 Hi Alley, Please go to below path and try it. Options - (click on) Change data source - (select) change data source - give the data range -Done- refresh your pivort table
Hi Alley, Please go to below path and try it. Options - (click on) Change data source - (select) change data source - give the data range -Done- refresh your pivort table
T Tushar Mehta Aug 27, 2008 #3 What does that mean? That the tables/charts don't update automatically? Or that even if you refresh by hand the new data are not included? I am working in Excel 2007 and when I update my source data, charts in other sheets do not get updated. Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products
What does that mean? That the tables/charts don't update automatically? Or that even if you refresh by hand the new data are not included? I am working in Excel 2007 and when I update my source data, charts in other sheets do not get updated. Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products