Excel STOCKHISTORY Function not working - Jan 1st, 2026

Hwy17 500 Reputation points
2026-01-01T22:26:17.78+00:00

Hi: We have been using STOCKHISTORY to load historical data in Excel workbook for about 20 stocks. For some reason today morning its not working and now is almost 3 hrs.

Microsoft 365 and Office | Excel | For business | Windows

8 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Vivian-HT 17,905 Reputation points Microsoft External Staff Moderator
    2026-01-02T01:03:02.45+00:00

    Dear @Hwy17,

    Thank you for posting your question in the Microsoft Q&A forum.

    I understand how disruptive it is when STOCKHISTORY suddenly stops working. According to my research, many users have reported this issue. However, Jan 1 is a market holiday in many regions. Before giving you the best solution, could you please confirm these questions below to help me diagnose the issue more effectively: 

    • What exact error message do you see in the cells?
    • Does STOCKHISTORY fail for all tickers or only some of them?
    • Are you using Excel on desktop, Excel for the web, or both? Does the function fail in Excel for the web as well?
    • Have you recently updated Office or changed accounts? If not, I recommend you try update Office (File > Account > Update Options > Update Now)
    • Whether the STOCKHISTORY issue also happens on another device or when using a different Microsoft 365 account?
    • Which Microsoft 365 subscription you are currently using?

    In the meantime, here are some steps I recommend you try:

    Step 1: Try opening the same file in Excel for the web or creating a new file for testing

    Step 2: Refresh your Excel session

    • Sign out of Excel (File > Account > Sign out)
    • Close Excel completely
    • Restart your computer
    • Open Excel and sign back in

    Step 3: Repair Microsoft Office Apps

    Repair options from the Settings page

    • Select Start > Settings > Apps > Installed apps.
    • Select the More ... icon next to the app you want to fix.
    • Select Advanced options (some apps don't have this option).
    • Select the Microsoft 365 or Office product you want to repair, click the ellipses, and select Modify.
    • In the page that opens, select Repair if it's available. If it isn't available or doesn't fix the problem, select Reset.
    • For more tips, see Repair an Office application.

    Note: Depends on your Microsoft 365 or Office installation type (Click-to-run or MSI-based), you'll see the following options to proceed with the repair. Follow the steps for your installation type.

    Repair options from the Control Panel

    • In the search box on the taskbar, enter control panel and select Control Panel from the results.
    • Select Programs > Programs and Features.
    • Right-click the program you want to fix and select Repair, or if that’s not available, select Change, then choose Quick Repair (or Online Repair if needed).
    • Then follow the directions on the screen.

    Step 4: Report a problem

    If the problem continues, I recommend you report an issue directly inside the Excel app so the Microsoft product team can review the logs and investigate the behavior by go to Excel > Help > Feedback > Report a problem

    Note: Please understand that as forum moderator, my primary goal is to provide helpful guidance and support through general troubleshooting steps. While I don’t have access to internal systems or test devices required to resolve backend issues, I truly appreciate your understanding of these limitations. I genuinely hope the information I share helps guide you in the right direction, and I'm always here to assist as much as I can within my scope.  

    I hope this information is helpful. Please follow these steps and let me know if it works for you. If not, we can work together to resolve this. If I misunderstand anything, please feel free to reach out.

    Please understand that the initial response does not always resolve the issue immediately. However, with your help and more detailed information, we can work together to find a solution.

    Thank you for your patience and your understanding. If you have any questions, please feel free to reach out.

    I'm looking forward for your reply.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

  3. AI answer

    2026-01-01T22:26:23.3066667+00:00

    If the STOCKHISTORY function in Excel is not working, there could be several reasons for this issue. Here are some common troubleshooting steps you can take:

    1. Check Internet Connection: Ensure that your internet connection is stable, as the STOCKHISTORY function requires access to online data.
    2. Excel Updates: Make sure that your Excel application is updated to the latest version. Sometimes, bugs in older versions can cause functions to fail.
    3. Function Syntax: Verify that the syntax of the STOCKHISTORY function is correct. Ensure that you are using the correct parameters for the function, such as the stock symbol, start date, and end date.
    4. Service Availability: Occasionally, the data service that provides stock history may experience outages or maintenance. Check if there are any announcements regarding service interruptions.
    5. Excel Limits: If you are trying to pull a large amount of data, ensure that you are not exceeding any limits set by Excel for data retrieval.

    If the problem persists after these checks, consider reaching out to Microsoft support for further assistance.

    References:

    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.