How can i get rid of the message "too many different cell formats"

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

Guest

I am trying to copy or move a worksheet from one book to another. when i do
this, it just changes the whole format of the sheet and does allow to do any
thing on that moved sheet in the new workbook and gives me an error " Too
many different cell formats".
 
try here:
http://www.quarrell.demon.co.uk/QAid/

or here:
http://support.microsoft.com/kb/213904

This oftem seems to happen when working with workbooks that have been used
in different language version of Excel.
Changing all fonts to 1 type eg arial should normally fix it, if not change
the font colour, then the size etc. Do fix it though otherwise one day your
workbook might not open.

cheers
Simon

Blog: www.smurfonspreadsheets.net
Website: www.codematic.net Excel development, support and training
 
Back
Top