Update & Upgrade Problems

Why Excel STOCKHISTORY and PDF Import Are Missing in Microsoft 365

Muhammad TalhaMuhammad Talha Oct 29, 2026 868 views

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.

Why Excel STOCKHISTORY and PDF Import Are Missing in Microsoft 365
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.
Before you start

Ensure that you have an active Microsoft 365 subscription and that you are logged into the correct Microsoft account associated with that subscription.

Solution 1Recommended

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.

1
Check for updates

Open Excel, go to 'File' on the top ribbon, and click on 'Account' at the bottom left.

2
Update Options

Under 'Product Information', click on the 'Update Options' drop-down button and select 'Update Now'.

3
Wait for availability

If the features are still missing after updating, you simply need to wait until Microsoft enables the feature flag for your specific account.

Keep Office Updated and Wait for the Feature Rollout
Staged Rollouts: Users cannot manually force a feature flag to turn on. The best approach is to ensure automatic updates are enabled and check back periodically.
Free Microsoft Office alternative

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.

Seamless compatibility with Microsoft Excel (.xlsx, .xls, .csv) formatsBuilt-in PDF reader, editor, and converter without requiring extra add-insFree, lightweight, and runs smoothly on older devicesFamiliar user interface makes switching easy and seamless
microsoft office alternative - wps office

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.