I have a template excel file with two charts and one set of data.
Using ASP I am updating the dataset with the appropriate values. That
works fine, however when the XLS file is opened, the chart does not
reflect the new values. The only way I have found to update the chart
is to change one of the cells in the data range, then change it back.
Can I create a macro that will run when the file is opened so that the
charts will auto refresh?
TIA.
Bookmarks