![]() |
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. |
All times are GMT +1. The time now is 02:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com