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.
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
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).
I have had the same issue since August 16th or 17th (Not sure exactly when I first saw the problem.) Also have spent lots of time since then trying to chase down the cause/solution without success.
I am finding that the frequency and specifics, (stock, date(s)), of the erroneous cells change when I refresh my workbook. They never all work, and at least a few work each refresh, just not the same ones every time.
And I waited until they did a normal update instead of the Preview beta test version. Should have waited a bit longer.
I don't want to divert this thread, but there also seems to be other issues with Release 2408. The window layouts of the Visual Basic editor appear to have changed. Moving back and forth between the underlying spreadsheet and the editor is different.
This is less important than the broken stock quote system.