Prev: cursor changes to arrow dash arrow in worksheet
Next: CHANGE TEXT DATE TO NUMERIC DATE
From: MICHAEL JONES MICHAEL on 3 Jan 2010 16:31
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?
From: Max on 3 Jan 2010 18:19
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
--
Max
Singapore
---
"MICHAEL JONES" wrote:
"> 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? "

 | 
Pages: 1
Prev: cursor changes to arrow dash arrow in worksheet
Next: CHANGE TEXT DATE TO NUMERIC DATE