- Aug 29, 2012
Last year using Excel 2010 I had web page downloads to worksheets upon opening the worksheets. This year my company upgraded to 2016 and I was getting errors on my refreshes so I am attempting to create a new worksheets with new links to the web pages for download. But Excel 2016 is WAY different than Excel 2010. I go to Get & Transform Data and choose from Web and enter the url. The importing comes up in tables and while the data I want to copy is in the tables when I try to load it the option "to existing worksheet" A1 cell is grayed out. I then choose a table and while it does add it to a new worksheet when i try to manipulate the data I get the error that the network connection has been lost or it puts it into a query worksheet. I need just the basics again! Screen scrape a web page into text in a worksheet then when I open the workbook it refreshes the data.