copying worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to copy a worksheet in which one of the cells has more than 255
characters. I get an error when I try to copy. Can anyone tell me why? And
is there a different work around rather than copying one cell at a time?

Thanks
 
This is the exact 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 of each cell are
copied. To copy all of the characters, copy the cells to a new sheet instead
of copying the entire sheet."

I guess I am just curious as to why you can put thousands of characters in a
cell if you can not copy them. The question actually came to me from one of
my students. I am running 2003 and 2007. This error does not occur in 2007.

Any ideas on how to get around the copy one cell at a time?
 
I wouldn't call it a bug. It looks like a limitation in 2003 that was
improved (or fixed) in 2007.
 
Back
Top