Forum Discussion
Solved
=WEBSERVICE() Refresh
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. Whe...
- 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()
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()
- 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()
I was having the same problem.
At first I was afraid that every time a cell was changed WEBSERVICE() would make a new request and quickly block the API (I have a daily limit), then I found out the opposite was true, no update.
Ideally it would be nice if there was a "update frequency" parameter in the function, or that it refreshed along side the power query and queries stuff.
JKPieterse your "=WEBSERVICE(...) + 0*NOW()" is automatic and incredibly elegant, works like a charm.Jan Karel --- I asked for an elegant solution --- global search and replace "=" with "=" certainly qualifies!!
Thanks much for the great suggestion.
- Excellent, glad you like the suggestion :-)
