inserting rows, without losing formulas??
Posted by Helena C on October 16, 2000 4:00 PM
I'm a beginner and I need help.
I have an enormous spreadsheet that I have to update.
I have to keep all existing formulas in the spreadsheet.
I have to insert 500 rows. I have existing formulas
that link to another part of the spreadsheet.
But everytime I insert the rows. It loses the information.
For example, =May!D245
After inserting the rows, =May!Ref#.
Is there a way I can insert rows without losing the information.
I can't use a paste special, value.
I need to keep where it is orginally pointing to.