How can I lock the links between worksheets? I have a Excel
spreadsheet that contains seveal worksheets and these sheets have links
between cells. My plan is to paste my raw data in to a specific sheet
and perform necessary sorting and calculations in other sheets.
Unfortunately, my data files don't all have the same number of lines
and when I insert a line in the raw data worksheet to compensate for
the difference, my linked cell change by the number of lines I insert.
I've thought of changing the references from relative to absolute, but
that would require the selection of several hundred indivial cell and
several hundred F4's (I can't find a way to F4 a large group of cells).