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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2024-08-22T21:54:53+00:00

    I see everything working again as well. 👍🏼

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-08-22T17:56:02+00:00

    I am happy to report that as of this morning, I am not encountering any #CONNECT! issues with the STOCKHISTORY() function.

    Thank you to Microsoft for responding to this issue quickly and to everyone that participated in this thread.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-08-21T21:32:25+00:00

    Completely agree!
    it's extremely critical function for me as I make decisions based on the data received using the function and it is happening since more than a week now

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-08-21T19:50:09+00:00

    As a user, I cannot separate Microsoft from the data provider that Microsoft contracted with in order to offer this valuable capability to Excel. So any finger pointing to an "external provider" is not encouraging I am surprised by the absence of automated monitoring of the service.

    I know that Microsoft cannot be happy with this issue and hope that it can be resolved quickly.

    Thank you for your attention.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2024-08-21T19:15:37+00:00

    My StockHistory functions rely on Dates in different cells. And when I change the dates the #Connection errors will go away (I actually change a cell that feeds into the date that changes the date).

    Was this answer helpful?

    0 comments