accessing STOCKHIISTORY data in Excel

robert dunbar 0 Reputation points
2026-11-06T18:14:51.9366667+00:00

I am using Excel in Windows on a desktop computer. My internet connection is working. I insert the following syntax =STOCKHISTORY("MSFT",DATE(2026,11,5),DATE(2026,16,6)). I get an error message #BLOCKED!

Microsoft 365 and Office | Excel | For home | Windows

2 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Hendrix-V 20,790 Reputation points Microsoft External Staff Moderator
    2026-11-07T04:36:39+00:00

    Hi robert dunbar,

    Since the common formula, account, privacy, and connected-experience checks have already been covered, the most useful next step is to determine whether the issue is specific to the desktop app:

    • Open the same workbook in Excel for the web.
    • Test the same STOCKHISTORY formula using a completed historical date.
    • If it works online but remains #BLOCKED! in desktop Excel, this helps narrow the issue to the desktop environment rather than the stock data itself.

    If both versions fail with the same historical dates, I recommend reporting it through Excel > Help > Feedback > Report a Problem, including the formula, affected dates, and the exact error.

    Please note that this is a user-to-user support forum. Moderators, contributors including external Microsoft employees cannot directly intervene in Microsoft product features or access back-end systems. Our role is limited to providing technical guidance on reported issues, requests, or ideas.

    I hope this helps narrow down the cause and avoids unnecessary changes to your installation.

    Was this answer helpful?

    0 comments

  2. AI answer

    2026-11-06T18:17:44.73+00:00

    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
    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.