"#CONNECT!" error on Cells that is connected to another data located in the same folder

This is issue is erratic. Sometimes it happens, and sometimes it doesn't. This is happening when the fil is opened in Teams or Excel Online. Sometimes it is also happening on Excel Desktop. Anyone wh...