Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I reset the default pie chart label "Other" to "Equity"? | Charts and Charting in Excel | |||
Mysterious "Arc" appearing at the bottom of the page | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"Identify Label" bug when using INDEX/MATCH and VLOOKUP formulas | Excel Worksheet Functions | |||
"Tabbing" code crashing xl2002 WinXP | Excel Programming |