accessing STOCKHIISTORY data in Excel

DATE(2026,16,6) means April 6, 2027, so first correct the end date to the date you intended and then distinguish the reported post-September 2026 feed problem from Excel’s documented access restrictions.

Excel uses DATE(year,month,day). When the month exceeds 12, Excel carries the excess into subsequent years; therefore, month 16 becomes April 2027.^1^

Correct the formula

Your current formula requests data from November 5, 2026 through April 6, 2027. It also includes future trading dates, for which completed historical data is unavailable; STOCKHISTORY generally updates only after a trading day is complete.^2^

If you intended June 16 through November 5, 2026, use:

=STOCKHISTORY("XNAS:MSFT",DATE(2026,6,16),DATE(2026,11,5))

XNAS:MSFT explicitly selects Microsoft on Nasdaq. The simpler "MSFT" is also valid and uses the default exchange.^2^

Determine which problem applies

Run this completed, earlier-date test:

=STOCKHISTORY("XNAS:MSFT",DATE(2026,9,4),DATE(2026,9,4))

• If September 4 works but dates after September 4–7, 2026 fail: this matches a widely reported STOCKHISTORY service/data-provider problem affecting later dates. Reports indicate no client-side workaround; Office repair or reinstallation did not correct it.^3^
  In Excel, select Help → Feedback → Report a Problem, include the formula and failing dates, and wait for the service feed to be restored.^4^ These reports describe missing-date or non-trading-day errors rather than #BLOCKED!, so the date-dependent test is necessary before treating the reported outage as the explanation.
• If the September 4 test also returns #BLOCKED!: troubleshoot access, licensing, and privacy settings instead. Microsoft defines #BLOCKED! as a required resource being inaccessible.^5^

If every date returns #BLOCKED!

1. Check the signed-in license
   • Go to File → Account.
   • Confirm Excel shows the intended signed-in Microsoft account and an activated Microsoft 365 subscription.
   • STOCKHISTORY requires Microsoft 365 Personal, Family, Business Standard, or Business Premium.^2^
2. Allow linked data types
   • Go to File → Options → Trust Center → Trust Center Settings.
   • Under Security settings for linked data types, select Prompt user about linked data types.
   • Recalculate the formula and approve the prompt.
   Avoid Enable all linked data types unless necessary, because Microsoft marks it as not recommended.^5^
3. Check connected experiences
   • Go to File → Account → Manage Settings.
   • Ensure connected experiences are enabled, then restart Excel. Microsoft documents this location for controlling Microsoft 365 connected experiences.^6^
4. If the option is unavailable or controlled by policy
   • On a managed computer, contact the organization’s Microsoft 365 administrator.
   • For a personal subscription, use Help → Feedback → Report a Problem and include the exact #BLOCKED! tooltip text, Excel version from File → Account, and whether the September 4 test succeeds.

An unsupported region can also produce #BLOCKED!; that condition is not resolved by changing the formula.^5^

References

1. DATE function | Microsoft Support
2. STOCKHISTORY function | Microsoft Support
3. Stock History not working since 09/04/2026 - Microsoft Q&A
4. Stock History Excel feed not working after 7th September 2026 - Microsoft Q&A
5. How to correct a #BLOCKED! error
6. Connected experiences in Microsoft 365 | Microsoft Support