Mysterious "Identify Label" is crashing Excel
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.
|