This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
I am facing the same issue since Saturday, Aug 17th. Any expectation for a fix?
It seems highly suspect that this issue seems to have started occurring when you probably released Microsoft® Excel® for Microsoft 365 MSO (Version 2408 Build 16.0.17928.20066) 32-bit (since I was able to find that Version 2407 was released on 8/13/24, my assumption is this issue seems to have started occurring with the probable release date of Version 2408)
Hello
Any update on finding a solution to this problem?
I did some digging around and was wondering if it has to do with the data provider. When you click into the data source for STOCKHISTORY it displays REFINITIV, if you click on that link it takes you to a LSEG Data & Analytics webpage.
I wonder if the problem has something to do with licensing or related to that.
THANKS FOR THE INFO
Seriously? This is the answer. I have had this problem now for 4 days and spent hours on this which led to another disaster. It is not acceptable. My spreadsheet is "dead in the water". I can't move forward without the values.