move spread sheet

[Guest]

Task cannot be performed (cut and paste, etc.) to insert a new worksheet into
a heavy worksheet with approxmateky 80 sheets.
Message from the systems is "there are too many different cells format"
Please inform how to perform a.m. task, taking into consideration that there
are no protected cells, the other way around, only template formats.
Thanks

Otavio

 

[Guest]

Otavio,

You need to clean up the formatting. Excel accepts around 4000 combinations
of cell formatting.

NOrmally, what people do and shouldn't is to select a whole column and
format it. This, for very large jobs like yours, can generate this kind of
problem.

You can got to Edit --> Clear --> Formats to clear formatting from empty
areas and see how it goes.