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.
It appears that the new issues I described are limited to a single file that I created over the weekend. STOCKHISTORY() does not manifiest the issues in older and newer files.
I will keep my fingers crossed.
This is NOT fixed as of 8/28/2024.
This is still happening, very often, as of 8/28/2024. For people like me, who use Refinitiv data extensively, it's terrible. Please do something about it. You offered Refiitiv as part of Excel, and it is not functioning properly at all.
I'm so sorry, it looks like the development team has introduced new issues while fixing the previous one. Please be patient, my supervisor is currently communicating with the development team. I will keep everyone updated on any progress.
Additionally, starting a new thread is a good idea. Microsoft may prioritize fixes based on the number of people reporting the issue in the community. The more new threads that report the same problem, the more urgent the situation will appear to the development team.
Thomas
I manually did a separate update of Excel 365 on my Mac today - even though it is supposedly set for automatic updates. After that, for a while, the STOCKHISTORY function worked fine. Then it deteriorated again into the same #CONNECT!, #CALC!, #SPILL!, #UNKNOWN! and other #N/As as before, including the Alerts for lack of resources etc.
On the phone waiting 45 minutes for Microsoft support but had to give up owing to work pressures.