LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
George Lynch
 
Posts: n/a
Default Identify Label €” More than one cell with label

I have a user who gets this dialog whenever she tries to modify a formula.
She wants to multiply an existing formula by the value that is in cell AV5.
However, when she activates the formula bar, then types an asterisk and an A
(intending, obviously, to continue to type "...V5", the Identify Label dialog
immediately pops up and says there is more than one cell with this label. It
shows an "a" (without the quotes).

It asks the user to select the cell containing the label to use. If she
types in AV5, she gets a message saying "That cell does not contain a valid
label."

If she cancels the Identify Label dialog, Excel immediately closes down.

I have not seen such behavior previously and we are seeking an answer to
this nasty problem.

Thanks in advance for any assistance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can't format cell - have tried unlocking and unprotecting griffin Excel Discussion (Misc queries) 1 April 5th 05 02:11 AM
Syntax for inferred cell references donesquire Excel Worksheet Functions 4 April 4th 05 09:29 PM
Can a Formula in Cell X modify Cell Y? alMandragor Excel Discussion (Misc queries) 7 February 10th 05 09:51 PM
identify data in a cell that has a number as the second character Brian Excel Worksheet Functions 1 December 12th 04 03:23 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM


All times are GMT +1. The time now is 06:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"