linked cells change to literals

[Guest]

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.

 

[Dave Peterson]

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 "helped" 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.