linked cells change to literals

Giganews Newsgroups
Subject: linked cells change to literals
Posted by:  Seamus
Date: Thu, 4 May 2006

My worksheet is a download from QuickBooks called Detail, with columns
through IV.  When creating the Summary and linking to the header cells, the
formula changes to a literal when attempting to insert a row, or changes to
the literal when attempting to change the cell address.  For example:  The
linked cell:

'detail-data'!a1 should be the header 110-04128 SBC in the summary.

If I insert a row into between a1 and a2 in the summary, and attempt to link
to 'detail-data'!a2, it shows as 'detail-data'!a2 and not the header.

Replies