Excel Excel Linking to Access - Chart doesn't update

[snoopy12]

Hi,

I have 4 worksheets in Excel 2007, each is linked to a separate query in Access. I set these up with a data connection to Access from the Data menu options in Excel. All these work fine and update correctly. Each of these worksheets is also linked to 4 seperate charts. My problem is that when I update the linked data, the charts don't update. The charts don't show the updated columns even though it is the same chart data range. Has anyone had any experience with this, and a way to fix it? What I have to do instead is to update the Chart Data Range manually.

Thanks!

 

[apr pillai]

Try after linking Excel Tables from Access, rather than the other way round.