This should be an easy one... i hope.
I want to add several sheets of web data to an existing workbook1 and refresh the information daily.
When I right click and "export to excel" from the web page, a new workbook2 automatically opens. I copy this new sheet to my original workbook1 but then it's no longer a web query. I can't refresh the data.
I can't remember how I got this to work in the past.
Excel 2007.
I want to add several sheets of web data to an existing workbook1 and refresh the information daily.
When I right click and "export to excel" from the web page, a new workbook2 automatically opens. I copy this new sheet to my original workbook1 but then it's no longer a web query. I can't refresh the data.
I can't remember how I got this to work in the past.
Excel 2007.