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.