I have two libre calc files where one is linked to the other. However if both files are open and I insert lines above the point at which the link occurs, the file with the link does not change to take into account the inserted lines. I know how to fix this problem in Excel, but can’t figure it out in Libre Calc. Please help.
Is it possible it has to do with relative vs absolute values? ie in inserting lines you have effectively changed the formula in the linking cells?