Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range cell content getting deleted
Hello, I am working in Excel 2000. I have file with a number of named
ranges set up. One named range is a cell where a series of sentences is written. After following the steps below the contact of the cell is corrupted - everything after approx 125 characters in the cell disappears. 1) Input Data 2) Save and Close File 3) Reopen file - After viewing the cell with the named range some of the content disappears. I have never experienced this before. Can anyone provide and explanation as to why this is happening and how to prevent the cell content from being deleted? This particular cell is called PROP_DESCRIPTION. Is there a ban on any of those words in the name of a named range? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range cell content getting deleted
I cannot replicate your problem. I do not see entering data into a cell
(named or otherwise) saving, closing and opening the file will corrupt the entry after 150 chars. Prop_sentence is not a reserved word in Excel so this is not an issue. Cheers Nigel "Bert" wrote in message om... Hello, I am working in Excel 2000. I have file with a number of named ranges set up. One named range is a cell where a series of sentences is written. After following the steps below the contact of the cell is corrupted - everything after approx 125 characters in the cell disappears. 1) Input Data 2) Save and Close File 3) Reopen file - After viewing the cell with the named range some of the content disappears. I have never experienced this before. Can anyone provide and explanation as to why this is happening and how to prevent the cell content from being deleted? This particular cell is called PROP_DESCRIPTION. Is there a ban on any of those words in the name of a named range? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy from one named cell to another dependent on content of a third. | Excel Worksheet Functions | |||
content deleted HELP! | Excel Worksheet Functions | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Changing named range reference depending on a cell's content | Excel Discussion (Misc queries) |