Excel has limitied number of characters it can move to another worksheet, it reports this error when moving it:
The sheet you are copying has cells that contain more than 255 characters.
only the first 255 characters in each cell are copied.
To copy all of the characters, copy the cells to a new sheet instead of copying the entire sheet.
User should have in mind to limit contents of cells or when moving to another worksheet,
it will be copied only via selecting the whole sheet and simple copy-paste to another worksheet.
However, format will not be as original.
No comments:
Post a Comment