Spreadsheet connection issues

[Ferru123]

Sometimes I have to click refresh loads of times to connect Gruss with a spreadsheet, as shown in the screenshot - should this be happening?

Also, I've found today that sometimes a spreadsheet 'drops out' - it's showing as being connected, but it's not refreshing. Is there anything I can do to prevent this?

Thanks

Jeff

[bolpx001]

I have found this too, usually if I have a lot of tabs open and updating my workbook. My solution is to slow down the update intervals, and when I have all the tabs in BA connecting decrease the update interval back to what it was. I have always assumed that I was asking too much of the system and it seldom happened so I just let it go, but I am very interested in any responses/advice/fixes - best regards Paul

[vanbuuts]

Yep same for me if I have more than 3 sheets open generally. Can take several refreshes to “find” the available workbook / sheets.

Been meaning to start a thread on this for a while now so glad someone else has got round to it. Would be interested as to any solutions and also if it’s possible to auto link each day using VBA - and how this works when one day has more meetings than others.