This is a strange new one for me. I was editing a formula. It already
contained: =Pricing_UMB!D52. I wanted to add to it. I hit F2. I typed at
the end of the existing formula *Pricing and then an Identify Label box
pops up. Never seen it before. Something about wanting me to identify a
table. But as far as I know I have no tables in the workbook. When I
pressed Cancel Excel blew up. If I entered Pricing_UMB!N29 it wouldn't
accept it, saying that the reference must be to a single cell on the active
sheet. Anyway I was able to delete the cell contents and type in the entire
formula. After crashing Excel numerous times. (And if I forgot to uncheck
the recover work I had to use Task Manager to kill Excel.)

Don <donwiss at panix.com.

On Sun, 16 Jan 2005 00:54:29 GMT, Don Wiss wrote:

This is a strange new one for me. I was editing a formula. It already
contained: =Pricing_UMB!D52. I wanted to add to it. I hit F2. I typed at
the end of the existing formula *Pricing and then an Identify Label box
pops up. Never seen it before. Something about wanting me to identify a
table. But as far as I know I have no tables in the workbook. When I
pressed Cancel Excel blew up. If I entered Pricing_UMB!N29 it wouldn't
accept it, saying that the reference must be to a single cell on the active
sheet. Anyway I was able to delete the cell contents and type in the entire
formula. After crashing Excel numerous times. (And if I forgot to uncheck
the recover work I had to use Task Manager to kill Excel.)

All is not well. This cell repeats with a slight variation. I was copying
and editing to get the others, but then I forgot and tried to edit one. Of
course Excel crashed and I had to start over. This time when typing the
entire line, after I typed the second "pricing," it wanted me to identify
the label. What I will have to do at this point is to put a cell with
=Pricing_UMB!N29 somewhere on the sheet and refer to that.

Don <donwiss at panix.com.

I searched the web and found that I had to uncheck "Accept labels in
formulas" on Tools - Options - Calculation Tab. Must be one of those
strange key combinations that you hit and it turns on some hidden feature.
The most famous being the one that turns the workbook into showing
formulas. That has surprised many a unsuspecting user.

Don <donwiss at panix.com.