Dear Members,
I have been using the STOCKHISTORY function (on Excel 365) for quite a while now.
Recently sometimes the function returns “#CONNECT!” error. This error (ERROR.TYPE is 10), is not described at all in MS documentation.
Sometimes, when accessing the function again (a short while later) may solve the problem. Unlike the “#BUSY!” error message, which is never returned to the user and keeps the calculation open (probably expecting a result within a short while), this “#CONNECT!” error terminates the calculation, giving the user an option to restart the entire calculation.
Since I can’t find anything in Microsoft docs, I had decided to ask if there is any other member who can shed some light on this phenomenon.
1000 THX,
--
I have been using the STOCKHISTORY function (on Excel 365) for quite a while now.
Recently sometimes the function returns “#CONNECT!” error. This error (ERROR.TYPE is 10), is not described at all in MS documentation.
Sometimes, when accessing the function again (a short while later) may solve the problem. Unlike the “#BUSY!” error message, which is never returned to the user and keeps the calculation open (probably expecting a result within a short while), this “#CONNECT!” error terminates the calculation, giving the user an option to restart the entire calculation.
Since I can’t find anything in Microsoft docs, I had decided to ask if there is any other member who can shed some light on this phenomenon.
1000 THX,
--
