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 currently requestin 10 years of monthly closes, so it's not a very large amount of data, and am still getting 90% errors...
Well, as of 11:31 am US Central Time, it's working again... Fingers crossed.
Spoke too fast. I am getting data for all stocks, but the dates are all wrong.
I feel your pain. This issue has cost me several thousand $ in lost productivity. I switched over to a paid data service with an Excel add-in: Ycharts. The cost is around $250 a month but it is well worth it. STOCKHISTORY() was an amazing function while it worked. I hope they get the bugs figured out.
Hi Jacques,
We have contacted them via email, but their response to us is "do not advise users to roll back their Office version, as it won't help" and "reassure the user and wait for the development team to fix it." I really wish I could help you but please forgive me there is nothing I can do at this time.
Thomas