Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default what is the problem" TOO MANY DIFFERENT CELL FORMATS"?

Hi,
I faced with a problem in my excel sheet. I made a big table with about 2400
cells. I used hyperlink files in one column. But recently I faced a problem
if I want format a cells, for example: merge two cells, it will send a
massage TOO MANY DIFFERENT CELLS FORMATS" and deny of do it. I don't knew
what happen in my excel sheet. I checked this sheet in another computer, I
haven't any problem. But in new computer, I couldn't use hyperlink of the
files.
Your reply will be highly appreciated.

Alireza

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default what is the problem" TOO MANY DIFFERENT CELL FORMATS"?

Maybe...

XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/default.aspx?scid=213904

A few people have said that OpenOffice.Org has been able to open the file. Then
they clean it up and save it there. Then excel can open that cleaned up
version.

http://www.openoffice.org, a 60-104 meg download or a CD

Alireza wrote:

Hi,
I faced with a problem in my excel sheet. I made a big table with about 2400
cells. I used hyperlink files in one column. But recently I faced a problem
if I want format a cells, for example: merge two cells, it will send a
massage TOO MANY DIFFERENT CELLS FORMATS" and deny of do it. I don't knew
what happen in my excel sheet. I checked this sheet in another computer, I
haven't any problem. But in new computer, I couldn't use hyperlink of the
files.
Your reply will be highly appreciated.

Alireza


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default what is the problem" TOO MANY DIFFERENT CELL FORMATS"?


There is a tool that helps you analyze, reduce and streamline the formatting
styles in your workbooks. It's a fix to the "too many different cell
formats" problem so many Excel users seem to experience.

It's available from the Office market place here :

http://office.microsoft.com/en-us/ma...938821033.aspx


And directly here :

http://xlsgenreduction.arstdesign.com/


Let me know what you think. ;-)



--

xlsgen - native Excel generator http://xlsgen.arstdesign.com
xlsgen RSS feed : http://www.arstdesign.com/BBS/rssxlsgen.php

"Alireza" a écrit dans le message de
...
Hi,
I faced with a problem in my excel sheet. I made a big table with about

2400
cells. I used hyperlink files in one column. But recently I faced a

problem
if I want format a cells, for example: merge two cells, it will send a
massage TOO MANY DIFFERENT CELLS FORMATS" and deny of do it. I don't knew
what happen in my excel sheet. I checked this sheet in another computer, I
haven't any problem. But in new computer, I couldn't use hyperlink of the
files.
Your reply will be highly appreciated.

Alireza



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Too Many Cell Formats" Error when opening a 2007 XLS file in 2003 James Excel Discussion (Misc queries) 0 November 3rd 09 02:14 AM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
"too many different cell formats". How to solve this problem? Eduardo Oliveira Excel Discussion (Misc queries) 2 February 29th 08 05:39 PM
what is the problem" TOO MANY DIFFERENT CELL FORMATS"? Alireza Excel Worksheet Functions 1 August 19th 06 01:22 PM
what is the problem" TOO MANY DIFFERENT CELL FORMATS"? Alireza Excel Discussion (Misc queries) 1 August 19th 06 01:22 PM


All times are GMT +1. The time now is 09:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"