Hi all,

I have a simple routine that places the latest months data from an Access database into an excel spreadsheet (Sheet1). Abbreviated code below:

Please Login or Register  to view this content.
On a seperate sheet (Sheet2), I have a graph that get's it's data from Sheet1 noted previously.

The graph is already set up and works fine for existing data. When I look in the spreadsheet I can see the latest months values have been exported from Access correctly, however, the graph on Sheet2 does not update to reflect the new data added. (The range in the graph does cover the new data added)

After a lot of investigation, it appears that Excel has not 'registered' (for the want of a better word) the values I exported. To confirm this, if I type the value manually and then press 'Enter', the graph then updates.

1 - How is this possible? I can clearly see the data yet Excel doesn't recognise it in the graph??
2 - Does anybody have a solution? Do I need to add an extra line to my code? Can I tell Excel to 'press the enter' key?
3 - Do I need code on start-up to register the values or re-calculate the charts?

Any help would be greatly appreciated, many thanks,

Staffs Lebowski