So every few times I refresh the code (or change something in my spreadsheet which results in the code re-running), I get a #CONNECT! error without the busy icon. Clicking on the error icon gives me "Service not available". Resetting the runtime fixes this error and allows the code to re-run, it's just annoying to keep having to click Reset Runtime. I have a Microsoft 365 family subscription. None of the code is circular, I just use it to tally something I can't do with just Excel formulae. I can share the spreadsheet if necessary.
(Basically the same thing is happening as this person: #61, but this got closed.)
So every few times I refresh the code (or change something in my spreadsheet which results in the code re-running), I get a #CONNECT! error without the busy icon. Clicking on the error icon gives me "Service not available". Resetting the runtime fixes this error and allows the code to re-run, it's just annoying to keep having to click Reset Runtime. I have a Microsoft 365 family subscription. None of the code is circular, I just use it to tally something I can't do with just Excel formulae. I can share the spreadsheet if necessary.
(Basically the same thing is happening as this person: #61, but this got closed.)