auto synch with multiple website tables

**jrtaylor** · 03-04-2011, 05:00 PM

I have a website which posts data from a workbook.

The workbook has several worksheets. Each worksheet contains a copy of a website table.

Is there a way for me to import data from the web automatically each time I open the workbook?

Thanks!

**mojo249** · 03-04-2011, 07:06 PM

Is your table a webquery? If so, there's an option to refresh on open.

Right click in your table and select Data Range Properties. Tick the box 'Refresh data when opening the file'.

**jrtaylor** · 03-04-2011, 07:47 PM

What if the web page has 6 or 10 tables in it. Can the web query handle this?

Thanks

**mojo249** · 03-04-2011, 07:53 PM

How is your workbook set up at the moment? Can you attach a copy?

**mojo249** · 03-06-2011, 11:33 AM

See the attached file.

To set it up, go to Data --> From Web. Paste the URL and click Import. Then right click anywhere in the table, select Data Range Properties and select Refresh the data when opening the file. You can also refresh at specified intervals.

Dion