Excel STOCKHISTORY() function repeatedly encounters #CONNECT! error.

Anonymous
2024-08-19T21:41:33+00:00

Hi Team,

I spent over 2 hours troubleshooting this issue with an advocate in Office support (7*********0). He worked very hard to understand and resolve the issue.

We tried numerous resets: the network, uninstalling and reinstalling office, updating office, powering down, and restarting the computer. Nothing helped.

The issue occurs in approximately 20% of the values for a list of stocks and one date. It occurs in a similar percentage of dates for a single stock.

Ultimately we discovered that creating a new spreadsheet and typing or pasting the formula into an empty cell will not result in the #CONNECT! error. But this does not work in previously created spreadsheets.

Please check on this as soon as possible. This is a critical function for applying Excel to stock research.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

54 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-09-26T12:33:34+00:00

    This is still a problem as of September 26.

    I am very unhappy. The whole reason I upgraded to Office 365 was to use STOCKHISTORY. That worked fine for a while but has been failing recently. Based on the discussion threads, it appears to me that Microsoft is not handling this with any sense of urgency -- it has been a problem for almost a month and a half now -- WAY too long for something as financially important to as many people as STOCKHISTORY is.

    I understand this is not a professional product, but (a) it is an advertised feature, (b) it has stopped working reliably, and (c) a month and a half to fix it is ridiculous -- especially for a financial product that people depend on. I understand that Microsoft says the problem is with their supplier. My response is: "Stop trying to make your problem be my problem!" Microsoft must own this problem, and they need to get urgent about getting it fixed! Microsoft's supplier is Microsoft's problem, so fix it! Now!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2024-08-29T12:13:34+00:00

    As of today (8/29/2024) things are back to #CONNECT! errors on roughly half of all the values of all my spreadsheets that use STOCKHISTORY.

    This is making them completely unusable, and I don't see a response from Microsoft.

    Please help.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2024-08-28T17:23:21+00:00

    Same here.

    Another issue worth noting is that when the data updates, I sometimes get a warning saying the not all tickers where updated and in such cases the most recent data is left. The problem is that it does not show which ticker did not update so it makes my formulas unreliable.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2024-08-28T15:07:06+00:00

    This is NOT fixed as of 8/28/2024.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2024-08-20T19:39:54+00:00

    THANKS FOR THE INFO

    Was this answer helpful?

    0 comments