| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot copy cell
Hi,
Have a workbook with cells that are merged and wrapped. The text in the cells often exceed 256 characters. I need to copy the information from one workbook to another formatted exactly the same. When I select the cell and copy then paste into the equivalent cell in the other workbook, I only get part of the text (probably the first 256 characters). If I try to copy the whole sheet over I get an error message that states "The sheet you are copying have cells that contain more than 256 characters. When you copy the entire sheet, only the first 255 charcters in each cell are copied." If I format a new workbook exactly the same as the original, I seem to have no problems copying a cell from one to the other. This indicates that there is something in the workbook setup that is inhibiting my copying the cells. Ideas would be most welcome especially since I have numerous workbooks to deal with by close of business today. Regards DavidC |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cannot copy cell
Need to add one further thing that I have just realised. One workbook is open
in one excel session, on one screen, the other is open in a separate excel session on another screen. I am using the split screen function to do the editing. "DavidC" wrote: Hi, Have a workbook with cells that are merged and wrapped. The text in the cells often exceed 256 characters. I need to copy the information from one workbook to another formatted exactly the same. When I select the cell and copy then paste into the equivalent cell in the other workbook, I only get part of the text (probably the first 256 characters). If I try to copy the whole sheet over I get an error message that states "The sheet you are copying have cells that contain more than 256 characters. When you copy the entire sheet, only the first 255 charcters in each cell are copied." If I format a new workbook exactly the same as the original, I seem to have no problems copying a cell from one to the other. This indicates that there is something in the workbook setup that is inhibiting my copying the cells. Ideas would be most welcome especially since I have numerous workbooks to deal with by close of business today. Regards DavidC |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cannot copy cell
Close one instance of Excel.
You can use WindowNew Window to see a view of two workbooks side by each. Gord Dibben MS Excel MVP On Thu, 28 Sep 2006 15:46:02 -0700, DavidC wrote: Need to add one further thing that I have just realised. One workbook is open in one excel session, on one screen, the other is open in a separate excel session on another screen. I am using the split screen function to do the editing. "DavidC" wrote: Hi, Have a workbook with cells that are merged and wrapped. The text in the cells often exceed 256 characters. I need to copy the information from one workbook to another formatted exactly the same. When I select the cell and copy then paste into the equivalent cell in the other workbook, I only get part of the text (probably the first 256 characters). If I try to copy the whole sheet over I get an error message that states "The sheet you are copying have cells that contain more than 256 characters. When you copy the entire sheet, only the first 255 charcters in each cell are copied." If I format a new workbook exactly the same as the original, I seem to have no problems copying a cell from one to the other. This indicates that there is something in the workbook setup that is inhibiting my copying the cells. Ideas would be most welcome especially since I have numerous workbooks to deal with by close of business today. Regards DavidC |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cannot copy cell
Try opening both workbooks in the same single instance.
DavidC wrote: Need to add one further thing that I have just realised. One workbook is open in one excel session, on one screen, the other is open in a separate excel session on another screen. I am using the split screen function to do the editing. "DavidC" wrote: Hi, Have a workbook with cells that are merged and wrapped. The text in the cells often exceed 256 characters. I need to copy the information from one workbook to another formatted exactly the same. When I select the cell and copy then paste into the equivalent cell in the other workbook, I only get part of the text (probably the first 256 characters). If I try to copy the whole sheet over I get an error message that states "The sheet you are copying have cells that contain more than 256 characters. When you copy the entire sheet, only the first 255 charcters in each cell are copied." If I format a new workbook exactly the same as the original, I seem to have no problems copying a cell from one to the other. This indicates that there is something in the workbook setup that is inhibiting my copying the cells. Ideas would be most welcome especially since I have numerous workbooks to deal with by close of business today. Regards DavidC -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cannot copy cell
Thanks for your help
Regards DavidC "Gord Dibben" wrote: Close one instance of Excel. You can use WindowNew Window to see a view of two workbooks side by each. Gord Dibben MS Excel MVP On Thu, 28 Sep 2006 15:46:02 -0700, DavidC wrote: Need to add one further thing that I have just realised. One workbook is open in one excel session, on one screen, the other is open in a separate excel session on another screen. I am using the split screen function to do the editing. "DavidC" wrote: Hi, Have a workbook with cells that are merged and wrapped. The text in the cells often exceed 256 characters. I need to copy the information from one workbook to another formatted exactly the same. When I select the cell and copy then paste into the equivalent cell in the other workbook, I only get part of the text (probably the first 256 characters). If I try to copy the whole sheet over I get an error message that states "The sheet you are copying have cells that contain more than 256 characters. When you copy the entire sheet, only the first 255 charcters in each cell are copied." If I format a new workbook exactly the same as the original, I seem to have no problems copying a cell from one to the other. This indicates that there is something in the workbook setup that is inhibiting my copying the cells. Ideas would be most welcome especially since I have numerous workbooks to deal with by close of business today. Regards DavidC |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cannot copy cell
Thanks for your help
regards DavidC "Dave Peterson" wrote: Try opening both workbooks in the same single instance. DavidC wrote: Need to add one further thing that I have just realised. One workbook is open in one excel session, on one screen, the other is open in a separate excel session on another screen. I am using the split screen function to do the editing. "DavidC" wrote: Hi, Have a workbook with cells that are merged and wrapped. The text in the cells often exceed 256 characters. I need to copy the information from one workbook to another formatted exactly the same. When I select the cell and copy then paste into the equivalent cell in the other workbook, I only get part of the text (probably the first 256 characters). If I try to copy the whole sheet over I get an error message that states "The sheet you are copying have cells that contain more than 256 characters. When you copy the entire sheet, only the first 255 charcters in each cell are copied." If I format a new workbook exactly the same as the original, I seem to have no problems copying a cell from one to the other. This indicates that there is something in the workbook setup that is inhibiting my copying the cells. Ideas would be most welcome especially since I have numerous workbooks to deal with by close of business today. Regards DavidC -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
| How to Copy the value of a cell to any given cell | Excel Discussion (Misc queries) | |||
| how to count the number of text frequencies and copy to other cell | Excel Worksheet Functions | |||
| hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions | |||
| How can I copy cell formats in functions? | Excel Worksheet Functions | |||
Linear Mode
