Fix Excel NOW() Function Showing Wrong Time in Embedded Mobile Workbooks
Question details
Users need to resolve a calculation discrepancy where the NOW() and TODAY() formulas display a time one hour earlier on mobile devices compared to desktop computers.
- Product
- Microsoft Excel Online
- Device & OS
- Windows, Mobile
- Scenario
- Viewing a OneDrive-hosted Excel workbook embedded in an HTML webpage via an iframe across multiple mobile devices and web browsers.
- Observed behavior
- The NOW() function shows the correct local time on Windows but displays a time exactly one hour earlier when the embedded workbook is accessed via mobile browsers.
Ensure that your mobile device's system clock is set to automatic and correctly recognizes your current time zone and Daylight Saving Time (DST) rules.
Synchronize Mobile Device Time Zone and DST Settings
Resolve the issue by ensuring the mobile device correctly reports its time zone and daylight saving status to the embedded Office web viewer.
The difference in time is typically caused by conflicting time zones reported by the mobile device, the mobile web browser, or the embedded Office viewer. Because the workbook calculates time dynamically using NOW(), any mismatch in device DST settings will result in an offset, often by exactly one hour.
On your mobile device, open the 'Settings' app and navigate to 'General' (iOS) or 'System' (Android), then tap on 'Date & Time'.
Toggle on 'Set Automatically' or 'Use network-provided time' to ensure your device applies the correct Daylight Saving Time offset.
Use a free online tool like whatismyip.com on your mobile browser to confirm that the web browser is broadcasting the exact same time zone as your Windows desktop.
Open the Workbook Directly in a Native App
Bypass the embedded web service and open the file natively to prevent web browser time zone misreporting.
View and Edit Spreadsheets Accurately on Any Device with WPS Office
Avoid browser-based calculation errors and embedded web viewer limitations by using WPS Office. Offering fully-featured native apps for Windows, Android, and iOS, WPS Office ensures your time formulas always reflect exact local device settings without iframe discrepancies.
- 1. Download the App: Install WPS Office for free from the official website or your mobile device's app store.
- 2. Open Your Workbook: Log into your cloud storage within WPS Office and open your .xlsx file directly.
- 3. Enjoy Accurate Editing: View, edit, and calculate your data accurately without relying on web browser rendering.
Frequently Asked Questions
Why does the NOW() function calculate differently in Excel Online versus desktop?
Excel Online calculates the NOW() function based on the time zone reported by the web browser or server viewing the embedded file. In contrast, the desktop application relies strictly on your computer's local system clock, which can lead to discrepancies if browser settings differ.
Can I force an embedded Excel workbook to display a specific time zone?
The NOW() function adapts dynamically to the viewer's environment. To lock a specific time zone regardless of the user's device, you would need to avoid volatile functions like NOW() and instead use a script to stamp a static time, or use an API to fetch the time from a specific region.
Does the TODAY() function suffer from the same mobile time zone issue?
Yes, because TODAY() also relies on the current date and time environment of the device. If a mobile browser reports an incorrect daylight saving time offset (shifting by an hour), calculations relying on TODAY() might roll over to the previous or next day prematurely.
