I've got a workbook with literally hundreds of cells (and growing) in multiple worksheets using =WEBSERVICE() to obtain data from an API.
When I open the workbook, the cells all show #VALUE. When I click on a cell and edit it, or just F2 and return, the #VALUE is replaced by the value returned by the API.
Is there a way to automate this refresh for an entire sheet or the entire workbook instead of a cell-by-cell update. I suppose I could write a macro to walk from cell-to-cell and sheet to sheet, refreshing cells as it progresses, but am hoping for a slightly more elegant solution...
I'd suggest either: - Do a global search and replace, search for = and replace with = (click options and select to search in workbook) - Add something to the cells which contain WEBSERVICE to make them recalculate each time, like =WEBSERVICE(...) + 0*NOW()
Best Response confirmed by
MartyK (New Contributor)