View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default "too many different cell formats" - one more time with FEELING

Instead of cutting and pasting, how about
copy
paste special|formulas
into that a new worksheet in a new workbook.

But it's difficult to believe that 308 cells (28 rows by 11 columns) would cause
this trouble.



stumped-in-excel wrote:

Running 2003 sp3 - getting error message.
Tried previous suggestions -
Formatstyle made changes but error message pops up not allowing changes to
be made.
Tried highlighting entire worksheet - rt clk - format - won't allow me to
make changes.
Tried cutting and pasting all but minimal data to separate worksheet -
clearing contents on blank fields - error still exists. This is with a data
field that's 28 rows X 11 col wide.

Help!!


--

Dave Peterson