I am having a problem with formulas that pull data from a sheet with web queries.
I have a macro set up to refresh 4 web queries when I click a button, which is working just fine.
However, I have other sheets that use formulas (V & HLOOKUPS) to pull numbers from the new data retrieved from the web queries. For some reason, when I refresh the web queries and then go to the sheets that pull data from them, the data is not there. If I click on the actual cell that contains the formula, and click enter, the data suddenly appears (as if I had to click Enter in order to refresh the formula?)
A lot of formulas are used to pull a lot of data from these queries, so it is too time consuming to go through & press Enter on every cell.
Any help or advice on how to solve this problem?
Bookmarks