Forum Discussion
Updating cell value automatically monthly or weekly etc.
Hi I am wondering if there is a way to update cell value automatically in certain period of time, for example monthly. I need this because I want to keep track of Customer Lifetime Revenue. W...
My understanding is that you can't do this with Excel alone. You need some form of trigger mechanism outside of Excel. Excel on its own cant launch itself and auto-execute code. If you had this file in OneDrive or Office 365, you could investigate about using the Excel actions to perform the update if it was in a table. It would be easier if you had some data in a SharePoint list that Flow could easily update, and your Excel just pulls from that data list and refreshes automatically.