Unanswered: Export data to Excel and refresh chart
From my access DB I am exportin/transfering a table to excel. It refreshes the existing data in the sheet with that table name. Now, I have a graph on a different sheet that refereces data on the sheet I just updated. When I open the workbook, the chart still contains the data from the old sheet. In order to get the chart to reflect he new data, I need to go into each row of the data that was changed and update a value.
Is there any way to have the data automatically refreshed?
Thanks for any help!
May sure the data you are exporting is of the type you used to create the chart in the first place.
For instance, if you have numbers in your Access table cells, but the data type is text, it will be text when it is exported to Excel, and the values will not reflect in the chart. If you export a table from Access into a spreadsheet in a workbook, and the datatype is exactly the same, the chart will be updated when you open the workbook. I just tried it.