software

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.

And you are correctly entering the formula (with a leading equal sign), right?

My guess (saved from a previous post):

Excel likes to help.

Try this on a test worksheet.
Select A1 and hit ctrl-; (to put the date in the cell)
now select B1 and type: =a1

Notice that excel changed the format of B1 to match the format in A1.

Now format D1 as Text.
put ASDF in D1
put =D1 in E1
You see ASDF.

With E1 selected, hit the F2 key and then enter (to pretend that you're changing
the formula).

Excel has quot;helpedquot; you by changing that cell's format to text.

I don't know of any way of changing this behavior.

I just select the cell, and reformat it to General (or whatever I wanted). I
hit F2 and then enter (to reenter that formula).

Sometimes this feature is nice, sometimes it ain't.

Seamus wrote:
gt;
gt; My worksheet is a download from QuickBooks called Detail, with columns
gt; through IV. When creating the Summary and linking to the header cells, the
gt; formula changes to a literal when attempting to insert a row, or changes to
gt; the literal when attempting to change the cell address. For example: The
gt; linked cell:
gt;
gt; 'detail-data'!a1 should be the header 110-04128 SBC in the summary.
gt;
gt; If I insert a row into between a1 and a2 in the summary, and attempt to link
gt; to 'detail-data'!a2, it shows as 'detail-data'!a2 and not the header.

--

Dave Peterson