How to insert lines into a workbook without changing references?

  • Thread starter Thread starter MICHAEL JONES
  • Start date Start date
M

MICHAEL JONES

WORKING IN A MULTI REFERENCED DOCUMENT TRYING TO ADD LINE ITEMS AND GET
REFERENCE ERRORS. HOW DO I INSERT NEW LINE ITEMS WITHOUT CHANGING THE
REFERENCES THAT ARE IN PLACE?
 
Think your mistake in posting in all caps is putting off potential responders
getting back to you. I had to hunt for/put on my PROPER lens to read it,
darn. Never use all caps in your postings.

Ok, think you face these kind of errors because you/another user have either
cut/move or deleted rows/cols or sheets previously. These actions will
invariably destroy/mess up formulas pointing to those cells/ranges involved.
The easy solution? Don't do it. If you can't control mutilation of your
sheets/books by other users, INDIRECT may allow you some respite if the
links/points are between sheets within the same book or between
source/destination books which are simultaneously open (it doesn't work if
the source books are closed). Any worth? hit the YES below
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

absolute reference fill 1
insert blank row and formulas 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Insert a new line, without destroying the consistency of the formu 10
Word to Excel: Export comments with text and line number 0
Excel Reference to text returning "0" value on second column 0
Absoute Cell Ref Changes When Inserting New Row in Referenced Shee 8
Is there a way to copy cells with absolute reference gettingadjusted? 3

Back
Top