Function Problems

Fix STOCKHISTORY Returning #NAME? Error in Excel for iOS

Elise WilliamsElise Williams Nov 2, 2026 870 views

Question details

The STOCKHISTORY function displays a #NAME? error when an Excel workbook is opened on an iOS device.

How to Fix STOCKHISTORY #NAME? Error in Excel for iOS
Product
Microsoft Excel
Device & OS
iOS
Scenario
Opening an Excel workbook containing the STOCKHISTORY formula with linked Stock data types on an iPhone or iPad.
Observed behavior
The formula calculates correctly on macOS but returns a #NAME? error on Excel for iOS.
Before you start

Ensure you have access to a desktop computer (Windows or Mac) or a web browser, as resolving this issue requires logging into a supported platform.

Solution 1Recommended

Open the Workbook on a Supported Desktop or Web Platform

Since STOCKHISTORY is not supported on mobile apps, opening the file on a supported desktop or web platform is the most direct way to view the data.

The STOCKHISTORY function relies on premium data types that are exclusively available to Microsoft 365 subscribers using Excel for Windows, Excel for Mac, or Excel for the web. Mobile versions of Excel, including iOS and Android, do not currently possess the necessary infrastructure to compute this function, resulting in the #NAME? error.

1
Save to cloud storage

Ensure the workbook you were trying to view on your iPhone or iPad is saved to OneDrive, iCloud, or another cloud storage service.

2
Access a supported device

Switch to a Windows PC, a Mac, or a device with a modern web browser.

3
Open Excel

Launch the Excel desktop application or navigate to Excel for the web (office.com) and log in with your Microsoft 365 credentials.

4
Load the workbook

Open the saved workbook. The STOCKHISTORY function will automatically recalculate and display your stock data correctly without the #NAME? error.

Open the Workbook on a Supported Desktop or Web Platform
Microsoft 365 Subscription Required: Even on supported platforms, you must be signed into an eligible Microsoft 365 account to use the STOCKHISTORY function.
Free Microsoft Office alternative

Enjoy a Seamless Mobile Spreadsheet Experience with WPS Office

If you frequently encounter feature limitations or compatibility errors on mobile devices, try WPS Office. It provides a lightweight, highly compatible alternative to Microsoft Office, ensuring you can view, edit, and manage your spreadsheets effortlessly on the go.

Excellent format compatibility with Microsoft Excel (.xlsx, .xls) files.Lightweight and optimized mobile app for fast, reliable spreadsheet viewing on iOS and Android.Familiar user interface reduces the learning curve and makes migration seamless.Free to use with comprehensive tools for managing data anywhere.
microsoft office alternative - wps office

Frequently Asked Questions

Why does the #NAME? error specifically appear when using STOCKHISTORY on mobile?

The #NAME? error generally occurs when Excel cannot recognize a function's name. Because the STOCKHISTORY function is completely absent from the code of Excel's mobile apps, the app interprets the function as an unrecognized text string, thus triggering the error.

Will Microsoft add STOCKHISTORY support to Excel for iOS in the future?

Microsoft continually updates its mobile applications, but currently, there is no official timeline for bringing linked data types and the STOCKHISTORY function to Excel for iOS or Android.

Can I use the STOCKHISTORY function with a free Microsoft account on the web?

No. The STOCKHISTORY function is a premium feature linked to specific financial data providers. It requires an active Microsoft 365 subscription to work, even on supported platforms like Excel for the web.