Fix STOCKHISTORY Returning #NAME? Error in Excel for iOS
Question details
The STOCKHISTORY function displays a #NAME? error when an Excel workbook is opened on an iOS device.

- 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.
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.
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.
Ensure the workbook you were trying to view on your iPhone or iPad is saved to OneDrive, iCloud, or another cloud storage service.
Switch to a Windows PC, a Mac, or a device with a modern web browser.
Launch the Excel desktop application or navigate to Excel for the web (office.com) and log in with your Microsoft 365 credentials.
Open the saved workbook. The STOCKHISTORY function will automatically recalculate and display your stock data correctly without the #NAME? error.

Convert STOCKHISTORY Formulas to Static Values
Use this method if you strictly need to view the stock data on your iOS device without encountering formula errors.
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.

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.




