Libreoffice crash when updating linked table takes too long

I have a librecalc document that has external linked data to update a table. It froze libreoffice very often and force close is needed to terminate libreoffice. 7 out of 10 times I need to force close and recover and it is driving me crazy.