|Subject:||linked cells change to literals|
|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
'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.