Forum Discussion

Copper Contributor

Aug 04, 2022

Solved

Automatic recalculation of functions

Let me introduce a use case (I intentionally tried to make it realistic): Suppose we are building a simple dashboard in Excel. The data is coming from a Web API (we are calling =WEBSERVICE functi...

developer

excel

Formulas and Functions

JKPieterse
Aug 10, 2022
cmukesh19 you can post Excel feature suggestions in this forum: https://feedbackportal.microsoft.com/feedback/forum/c23f3b77-f01b-ec11-b6e7-0022481f8472

JKPieterse

Silver Contributor

Aug 04, 2022

You could do this with a bit of VBA. Consider the last answer in this thread:
https://stackoverflow.com/questions/22772898/how-to-have-vba-execute-every-10-minutes

cmukesh19
Copper Contributor
Aug 10, 2022
As mentioned in the discussion - why could we not make this a feature of function itself? Just to repeat myself, with new Lambda/ new functions, we could do a lot without ever needing to resort to VBA.
There are many situations where macros are not allowed/ there are users who are not developers.
- JKPieterse
  Silver Contributor
  Aug 10, 2022
  cmukesh19 you can post Excel feature suggestions in this forum: https://feedbackportal.microsoft.com/feedback/forum/c23f3b77-f01b-ec11-b6e7-0022481f8472
  - cmukesh19
    Copper Contributor
    Aug 10, 2022
    Please vote this feature at
    https://feedbackportal.microsoft.com/feedback/idea/aceca1b8-b318-ed11-a81b-6045bd7d68ae