Software

Ask something
Discussion Locked

Refresh Data in Excell from Access

0 helpful
3 replies

by dennisbv

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am doing a program to generate a report from Access. The data comes from an RS6000 through an Excell worksheet using a Microsoft Query, That I have linked to Access. What I want to do is when the report is run Access to open the Excell sheet (toget the most current data)and I need the Excell sheet to automaticly refresh it's self. Right now I have to click on refresh data from the menu. How can I have the excell sheet automaticly refresh itself?
Dennis

3 replies

by dklippert

Here's a here's a suggecstion from the Help file:
"Refresh automatically: You can refresh an external data range automatically when you open the workbook, and optionally save the workbook without saving the external data, so that the workbook file size is reduced. On the External Datatoolbar, click Data Range Properties , and then select the Refresh data on file open check box. To save the workbook with the query definition but without the external data, select the Remove external data from worksheet before saving check box."

This discussion is closed to new replies.