LO 24.02 on MACOS - calc links breaking sporadically

.I updated numbers in one calc sheet from another calc sheet with using **='file:///Users/… specifying the full path, the tab name, and the specific cell and sporadically this just breaks showing and error my requesting spreadsheet. I have allowed updated links always from trusted locations on the previous versions of LO but cannot seem to find that on 24.02. If I click the cell for the calc sheet to update the requesting sheet with the exact same information it relinks and works for awhile. This was happening before I moved to the 24 version of LO so this is an old issue.