M
maijiuli
Hello,
I'm working on a project which I'm 1/3 responsible for. The 3 of us are
using seperate copies of the same excel document and we enter data into the
cells.
We are done with our project. Now we would like to merge our workbooks into
1 master workbook.
I use the "group" function to group all of my worksheets and then "move or
copy" function to copy into the Master workbook.
The problem is I keep encountering this error:
"The sheet you are copying has cells that contain more than 255 characters.
When you copy the entire sheet, only the first 255 characters in each cell
are copied."
Is there a way to simply copy all worksheets from 1 WB to another WB and
catch all characters in all cells. Note: some cells have colors/font/ and
formatting (spacing & tabbing).
Thanks in advance,
I'm working on a project which I'm 1/3 responsible for. The 3 of us are
using seperate copies of the same excel document and we enter data into the
cells.
We are done with our project. Now we would like to merge our workbooks into
1 master workbook.
I use the "group" function to group all of my worksheets and then "move or
copy" function to copy into the Master workbook.
The problem is I keep encountering this error:
"The sheet you are copying has cells that contain more than 255 characters.
When you copy the entire sheet, only the first 255 characters in each cell
are copied."
Is there a way to simply copy all worksheets from 1 WB to another WB and
catch all characters in all cells. Note: some cells have colors/font/ and
formatting (spacing & tabbing).
Thanks in advance,