Forum Discussion
#CONNECT! Error - Stockhistory down?
Is anyone else having this issue with stockhistory? I am receiving the #CONNECT! error randomly, sometimes it works, sometimes it doesn't. I can change the time period, shorter or longer, and it just...
Almost a week from the first occurence of the issue, and today I got 100% data returned (63 stocks out of 63, with 5 diffrent date ranges and data selections)
rifhickman How did you manage to get it fixed? My excel is still not pulling data for more than 50% of the stocks i'm using stockhistory on.
- Just opened excel, and it was fine
- Yes, looks much better today but I see that today's values are still not updated (#VALUE error). The values are good till yesterday. Something seems to have been fixed.
adpathania1 mine finally returned all values yesterday afternoon as well. You might try logging out of 365, rebooting, then logging back in. Worked for me.
dab662430 just tried logging out, resetting the computer, and logging back into 365. Same problems occurred. I was able to get some data to load but dates would be way out of order. Seems like it’s a data problem on their end.
- That’s strange. The only other items I can think of: make sure you have installed the latest Windows update, as well as 365 version. Beyond those, you might need to contact Microsoft. It’s now working fine for me - and I’m pulling about 460 prices across the last 70 days. Hope it works out for you.
