Home |
Search |
Today's Posts |
#1
|
|||
|
|||
More than one cell with label
I am plagued with an Identify Label popup when when pasting large MS
Word documents into Excel. The message is "There is more than one cell with this label". In the text box there is the letter "a". The instruction is "Select the cell to contain the label to use". Whatever cell I enter, e.g. "A1", I get a popup with the message "That cell does not contain a. Use it anyway?" If I click Yes or No or Cancel, the Identify Label repeats. I have to use Task Manager to close Excel. Tools : Options : Calculation : Accept labels is off. The MS Word documents all have paragraphs of 15 words separated by tabs. That is to say that I need one word per cell in Excel. A typical document might be 49 A4 pages long. The work around that I'm using is to first paste 20 pages, then 29 pages. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |