Meet ONLYOFFICE Docs Cloud, complete office software as a service
Meet ONLYOFFICE Docs Cloud

Recalculation of formulas in a table

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.