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...
Update on my side - looks to be excel deliberately throttling the data, only workaround is to stagger the formulas and/or to delete the cell with the formula in and re-paste it in.
So now will have to make some vba to check if the #CONNECT! error is in the cell, and if true, will have to delete the formula in the cell and repaste it in until it finally provides the data. Unless of course this is a temporary issue
So now will have to make some vba to check if the #CONNECT! error is in the cell, and if true, will have to delete the formula in the cell and repaste it in until it finally provides the data. Unless of course this is a temporary issue