Good afternoon, tell me how you can make a macro that will update and recalculate the values in the table cells every minute? it is the function that is of interest as when pressing “F9”, and not a simple page refresh.
Hello Draykn.
Unfortunately, we don’t have ready-to-go solution for your request.
Most likely, you need to try to implement a similar mechanism (recalculate the values) using a plugin. Unfortunately, we do not have a ready-made plugin example that you could be guided by in your research.
Hi, did you find any workaround? If there was a way to force getdata to pull data that may work?
As far as I understand, you created a separate topic for this question here: Update cell value from a URL real tme or once per spread sheet open
We are working on it, I will notify you when we have something to share.