Calculation Issues

Refresh TODAY() Data in Excel for the Web from PowerBuilder

Muhammad TalhaMuhammad Talha Nov 12, 2026 869 views

Question details

The user needs to refresh an Excel workbook accessed from PowerBuilder so that formulas such as TODAY() update without relying on VBA.

Refresh TODAY() Data in Excel for the Web from PowerBuilder
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.
Before you start

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.

Solution 1Recommended

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.

1
Store the workbook in a supported location

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.

2
Create an Office Script

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.

3
Create a scheduled cloud flow

In Power Automate, select Create > Scheduled cloud flow and set the recurrence that matches the required refresh interval.

4
Run the script from the flow

Add the Excel Online (Business) action Run script, select the workbook location and file, and choose the Office Script created for calculation.

5
Test the updated workbook

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.

Use a scheduled Power Automate flow with Office Scripts
Calculation requirement: A date formula changes when Excel recalculates the workbook. Merely leaving a workbook stored online does not guarantee that TODAY() will update at midnight.
Free Microsoft Office alternative

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.

Open and calculate common Excel formulas, including date-based formulas such as TODAY().Compatible with Microsoft Excel XLSX, XLS, and CSV file formats.Use a familiar spreadsheet interface for editing workbook data locally.Lightweight free office suite for routine spreadsheet review and updates.
microsoft office alternative - wps office

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.