Fix Excel NOW and TODAY Displaying UTC in Embedded Workbooks
Question details
The user needs to understand why dynamic time functions in an embedded Excel workbook display different time zones depending on the viewing device, and how to ensure consistent time display.
- Product
- Microsoft Excel
- Device & OS
- Windows, Mac, iPhone
- Scenario
- Viewing an Excel workbook hosted on personal OneDrive and embedded in a web environment.
- Observed behavior
- The workbook correctly displays the viewer's local time on a Windows laptop, but incorrectly displays UTC on Macs and iPhones when using the =NOW() or =TODAY() functions.
Verify whether your embedded workbook requires real-time viewer-specific time zones, or if a static global time (such as server time) is sufficient for your audience.
Use a Web Service or API for Fixed Time Zone Calculation
Since Excel lacks robust built-in time-zone handling for embedded web environments, replacing local time formulas with a web query ensures the time displays consistently across all operating systems.
Excel's native NOW() and TODAY() functions rely entirely on the environment hosting the embedded workbook. On macOS and iOS web browsers, cloud-hosted workbooks often default to Coordinated Universal Time (UTC). To fix this, you must stop relying on native dynamic time functions and instead pull a fixed time from a web service.
Determine if your viewers need to see a specific global time (like EST) or if you want to display the server's update time. Native formulas cannot reliably detect local time on iOS/Mac web embeds.
Use Excel's Power Query feature (Data > Get Data > From Web) to connect to a free time API (such as WorldTimeAPI). This pulls a standardized time string into a specific cell that won't change based on the viewer's device.
Add a clear text note in your embedded workbook, such as 'All times displayed in UTC', so viewers on any platform understand exactly how the time is calculated.
Convert Dynamic Formulas to Static Text
If you only need to show when the document was last updated, convert the formula into static text before embedding the workbook online.
Use WPS Office for Reliable Desktop Spreadsheet Management
If cross-platform cloud calculation issues in Microsoft Excel disrupt your workflow, consider using WPS Office. WPS Spreadsheet provides a highly compatible, robust environment for managing local and cloud files without the heavy overhead.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the software: Run the installer and follow the on-screen instructions to set up WPS Office on your computer.
- 3. Open your Excel files: Launch WPS Spreadsheet and open your existing .xlsx workbooks to manage your data accurately and efficiently.
Frequently Asked Questions
Why does Excel NOW() show UTC on my iPhone but local time on Windows?
When viewing embedded Excel workbooks on iOS or macOS browsers, the cloud hosting environment defaults to Coordinated Universal Time (UTC). This happens because mobile and Mac web browsers restrict server access to local system clocks for privacy, whereas Windows environments often share local system settings with Microsoft services.
Can I format the TODAY() function to force a specific time zone?
No, Excel's TODAY() and NOW() functions do not have built-in arguments to specify or force a time zone. They strictly pull the time from the system clock of the host server executing the embedded workbook.
Will changing my OneDrive account region fix the embedded workbook time?
Changing your OneDrive or Microsoft account region settings may affect how files appear inside the OneDrive web interface, but it does not override the system-level UTC default applied to anonymously embedded workbooks viewed on Safari or mobile devices.
