Expoting to Excel more than once

M

Matt

I have a form containing linked Excel charts that are refreshed each time the
Go button is clicked. The problem is when the data is exported to Excel the
first time, the Excel file remains open and not visible. If I try clicking
the Go button again to export and update my charts, I get an error message
stating the Excel file is already open. Any ideas on how I can fix this
problem?

Thanks,
Matt
 
Top