worksheet malfunction

[Guest]

Windows XP -Excel 2.003
Cut and paste malfunctions from a single spredsheet to another heavy sheet
with approxmately 80 sheets.
Message displayed is: There are too many diffrent cells format.
Please inform how to perform task taking into consideration that sheeets are
for templates.
Thanks

 

[Guest]

I was unable to find the link to the thread but run a search for "cells
format" in this forum and you'll see a post dated 9/24/04 in Excel General
which has some discussion and links to other web sites.

It didn't look encouraging.

 

[virendra.telkar]

Windows XP -Excel 2.003
Cut and paste malfunctions from a single spredsheet to another heav
sheet
with approxmately 80 sheets.
Message displayed is: There are too many diffrent cells format.
Please inform how to perform task taking into consideration tha
sheeets are
for templates.
Thanks

hi otavio,

what i understand is u want to cut & paste some cell to heavy sheet,

1-when u want to take data from on sheet to another which is very big
u need to copy as copy ,paste special, values...

2-if u are coping visible cells ,these arenot copied to another shee
wherein their is a auto filter given to the sheet

3-while coping to another sheet u always need to look where u r pastin
the copied cells, if the other sheet contains merged cells it will no
allow u to copy the same..

this might suffice , in case mail with exampleo
(e-mail address removed)

regards,

virendr