Thanks Anders, I looked around in the settings, data connections and options and could not see anything. Did not expect to find the refresh sett...
Thanks for the file and VBA script. The VBA works fine, opens IE and clicks on Accept. However after that, IE is open and running showing the web page...
I agree it would be better and more efficient to get the data from the website with Power Query but it does not work for me. I don't think they are ht...
Screenshots attached now. Locale date format is dd/mm/yyyy
I have now tried it using IE and it did not work for me. I opened the page first in IE and then clicked the Accept button. Then I started web PQ in Ex...
There appears to be some discrepancy here between what you are seeing and what I am seeing. In my workbook they are shown as dates Nov-Dec. I attached...
I found a solution to this by unchecking "Adjust column width" under the "Table Design" tab for the PQ table. See attached screenshot.
I stumbled upon a solution to solve this in excel and avoid using .csv files. I used a step which first converted the date column in to "text type" an...