Automatic "data refresh" when XLS file is opened?

  • Thread starter Thread starter L. Berger
  • Start date Start date
L

L. Berger

Hi, I have seven worksheets in my file, which come from online source
(our data server). Currently, the user has to manually do a 'Data
Refresh' everytime he opens the file, for each worksheet. How can I
make sure that everytime the XLS file is opened, the data from the web
site is automatically pulled and updated in the Excel file? Many
thanks for any pointer!
 
Record a macro when you do it manually.

Then name that macro Auto_Open
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refreshing formulas automatically 3
Run Macro Automatically When Excel 2003 Opens 2
Excel file extension is camouflaged as xls 1
Automatically update from source when file opens 1
Open .xlsx files in Excel 2002 2
any special trick to opening up corrupt XLS files 3
Error when Formula references a pivot table in an external workboo 2
Refresh Data 3

Back
Top