Why Excel STOCKHISTORY and PDF Import Are Missing in Microsoft 365
Question details
Users are unable to find the STOCKHISTORY function or the 'Get Data from PDF' option in Microsoft Excel, despite having a fully updated Microsoft 365 subscription.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Trying to use newly released Excel functions or data import features for financial analysis or document conversion.
- Observed behavior
- The STOCKHISTORY function and 'Get Data from PDF' feature are missing from the Excel interface and function library.
Ensure that you have an active Microsoft 365 subscription and that you are logged into the correct Microsoft account associated with that subscription.
Keep Office Updated and Wait for the Feature Rollout
Microsoft releases new features gradually using staged rollouts and feature flags, meaning not all users get them simultaneously.
Microsoft does not release all new features to every Microsoft 365 subscriber at the exact same time. Instead, they use 'staged rollouts' and 'feature flags' to gradually introduce updates.
This means that even if you have the same subscription, update channel, and build number as another user, you might still not see certain features like STOCKHISTORY or PDF Import until they are enabled for your specific account.
Open Excel, go to 'File' on the top ribbon, and click on 'Account' at the bottom left.
Under 'Product Information', click on the 'Update Options' drop-down button and select 'Update Now'.
If the features are still missing after updating, you simply need to wait until Microsoft enables the feature flag for your specific account.

Try WPS Office for Your Data and PDF Needs
Tired of waiting for unpredictable Microsoft feature rollouts? WPS Office is a free, lightweight, and comprehensive Office suite that offers powerful spreadsheet capabilities and built-in PDF tools without the confusion of staged feature flags.

Frequently Asked Questions
Can I manually enable the STOCKHISTORY function in Excel?
No, you cannot manually enable it if it hasn't been rolled out to your account. Microsoft controls feature availability via server-side feature flags.
Why does my colleague have the PDF Import feature but I don't?
Due to staged rollouts, users on the same network, subscription plan, or even the same software build can receive features at different times.
Does switching my Microsoft 365 update channel give me the features faster?
Switching to the Beta Channel or Current Channel (Preview) can sometimes provide early access to new features, but it is still subject to Microsoft's staged rollout process and does not guarantee immediate availability.




