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...
about a third of a list of 60+ stocks are affected. Close the workbook and reopen it, a different batch from the same list is affected. Has been like that since saturday morning, and continues today, Sunday.
rifhickman I have the same issue (on the 20th). Changing the date range fixes the issue some of the time, but only temporarily.
- I use my stock list to generate 5 year monthly prices, and the same list for 13 weeks last close and 5 days last close. The #connect occurs arbitrarily across all 3 lists. Any single stock has the #connect in any, and sometimes all the columns. It is almost certainly not in the excel arena
rifhickman Everyone on this thread needs to click on Help in Excel and contact Microsoft via chat to create a ticket. It seems Microsoft isn't addressing this. If enough people express concern, it just might get addressed. When I did this, they told me it was a server issue on their end. That was Sunday. This has been happening since Friday evening.
