Fix Excel STOCKHISTORY #CONNECT! Error on iPhone and iPad
Question details
The user is experiencing a #CONNECT! error when attempting to use the STOCKHISTORY function in Excel on an iPhone or iPad, even with an active Microsoft 365 subscription.
- Product
- Microsoft Excel
- Device & OS
- iOS and iPadOS
- Scenario
- Retrieving financial data using the STOCKHISTORY function on a mobile device.
- Observed behavior
- The function returns a #CONNECT! error, indicating a failure to retrieve or refresh the linked data.
Ensure your iPhone or iPad is connected to a stable internet network and that your Microsoft 365 account is actively signed into the Excel mobile app.
Verify Platform Support and Update Excel for iOS
Check Microsoft's platform requirements for the STOCKHISTORY function and ensure your Excel app is up to date.
Microsoft Excel's STOCKHISTORY function relies on linked-data refresh capabilities. These features are frequently restricted or unsupported on mobile operating systems like iOS and iPadOS. When the app cannot access the external financial data service, it triggers the #CONNECT! error.
Visit the official Microsoft Support website on your mobile browser to verify the current availability of the STOCKHISTORY function for iOS and iPadOS platforms.
Open the App Store on your iPhone or iPad, search for Microsoft Excel, and tap 'Update' to ensure you have the latest version containing recent feature rollouts.
If the feature remains unavailable, open the Excel app, navigate to 'Settings' (the gear icon), select 'Send Feedback', and report the missing functionality directly to the developers.
Edit Spreadsheets Seamlessly on Mobile with WPS Office
While advanced data-linking features like STOCKHISTORY may be restricted in Excel for iOS, WPS Office provides a robust, free, and highly compatible alternative for viewing and editing your spreadsheets on the go.
- 1. Download the App: Search for WPS Office in the Apple App Store and install it on your iPhone or iPad for free.
- 2. Open Your Spreadsheet: Launch WPS Office and open your existing Excel workbooks directly from your local storage or cloud drive.
- 3. Edit with Ease: Enjoy smooth spreadsheet editing, formatting, and standard formula calculation with a familiar interface.
Frequently Asked Questions
What does the #CONNECT! error mean in Excel?
The #CONNECT! error occurs when Excel cannot establish a connection to an external service to retrieve data. This typically happens when using linked data types (like Stocks or Geography) on unsupported platforms or during network connectivity issues.
Can I use linked data types on Excel for iPad?
Linked data types and their refresh capabilities have significant limitations on Excel for iPad and iPhone. While you might be able to view previously fetched static data, refreshing or adding new linked data generally requires the desktop version of Excel.
Is there a workaround for the STOCKHISTORY error on iOS?
The most reliable workaround is to open and refresh the spreadsheet using Excel on a Windows or Mac computer. Once the stock data is refreshed and the file is saved, you can view the updated static values on your iPhone or iPad.
Does an active Microsoft 365 subscription guarantee all features on mobile?
No. Although a Microsoft 365 subscription unlocks premium features in mobile apps, certain advanced functions and external data connections remain exclusive to the desktop versions of Excel due to mobile operating system constraints.
