I have existing Excel workbook containing numerous wkshts and charts. I want to be able to update the existing worksheets with a different Access datasource. This way I do not have to create duplicate charts. The reasons for the different datasource is I Need to display data for "All" selection that summarizes the data and 1 that is based on the selection criteria which is summarized differently. The Column numbers do not change just the rows.

Is there a way to export from Access to Excel with named ranges or to a specified worksheet.



Thanks,

Kfs

If you export a query to your pre-existing Excel file it will add a worksheet having the same name as the query.

-Phil-

Thank you for your input, and that is the problem- Is there a work around.

K

Thanks,

Kfs