Refresh TODAY() Data in Excel for the Web from PowerBuilder
Question details
The user needs to refresh an Excel workbook accessed from PowerBuilder so that formulas such as TODAY() update without relying on VBA.

- Product
- Microsoft Excel for the web with PowerBuilder integration
- Device & OS
- not provided
- Scenario
- A workbook is accessed through PowerBuilder and needs current date-based formula results while it remains stored online.
- Observed behavior
- The TODAY() formula updates only after the workbook is opened or processed by Excel, and VBA cannot run in Excel for the web.
Confirm that the workbook is stored in OneDrive for Business or SharePoint and that the account used for automation has edit access. Identify whether the workbook only needs formula recalculation or also needs to refresh external query data.
Use a scheduled Power Automate flow with Office Scripts
Use this option when you need a recurring cloud-based process to open or calculate an Excel for the web workbook without VBA.
Excel for the web does not support VBA macros. A scheduled Power Automate flow can run an Office Script against a supported workbook to trigger workbook calculation or update values on a schedule.
Move or save the workbook to OneDrive for Business or a SharePoint document library, then make sure the automation account has permission to edit the file.
Open the workbook in Excel for the web, select the Automate tab, choose New Script, and add a script that uses the workbook calculation APIs or writes a value that causes dependent formulas to recalculate.
In Power Automate, select Create > Scheduled cloud flow and set the recurrence that matches the required refresh interval.
Add the Excel Online (Business) action Run script, select the workbook location and file, and choose the Office Script created for calculation.
Run the flow manually from Power Automate, then reopen the workbook in Excel for the web and verify that the TODAY() result reflects the expected date.

Trigger workbook calculation through Microsoft Graph API
Use this option when PowerBuilder or another custom application needs to initiate workbook calculation programmatically.
Refresh the workbook manually in Excel for the web
Use this option when automated refresh is not required and a user can open the workbook when current formula results are needed.
Use WPS Spreadsheet for Local Excel Workbook Calculation
If your workflow does not require Excel for the web APIs, WPS Office provides a free, lightweight spreadsheet alternative for opening and calculating local Excel workbooks. Its familiar spreadsheet interface supports seamless migration for many everyday XLSX-based tasks.

Frequently Asked Questions
Why does TODAY() not update automatically in Excel for the web?
TODAY() updates when Excel recalculates the workbook. If no user or automation process opens, edits, or calculates the workbook, its saved result may remain unchanged.
Can PowerBuilder run VBA to refresh an Excel for the web workbook?
No. Excel for the web does not run VBA macros. For cloud automation, use supported options such as Power Automate with Office Scripts or Microsoft Graph APIs.
Can Power Automate refresh external data connections in an Excel workbook?
It depends on the data source and connector support. Power Automate can run Office Scripts and Excel Online actions, while Power Query refresh capabilities vary by query type and workbook location.
What is the best way to refresh TODAY() on a daily schedule?
Create a Scheduled cloud flow in Power Automate and use the Excel Online (Business) Run script action to execute an Office Script that triggers workbook calculation.
Can Microsoft Graph retrieve the recalculated cell value for PowerBuilder?
Yes. After authenticating to Microsoft Graph and triggering workbook calculation, an application can use workbook range, worksheet, table, or named-item endpoints to read the updated values.




