Will excel 2007 support more than 4,000 cell formats?

G

Guest

Does anyone know if excel 2007 will support more than 4,000 different
combinations of cell formats? They say "Excel 2007 supports spreadsheets up
to 1 million rows by 16,000 columns in size eliminating the need to work
within multiple spreadsheets or other applications you need to analyze large
amounts of information." What good is this if it won't support more than
4,000 combinations? I consistently go over that, and my workbooks aren't that
big! Don't misunderstand me I love Excel!

HELP?
 
N

Nick Hodge

Why would you go over 4,000 different cell formats? This has nothing to do
with the grid size. You can fill them all and have one format. (Not
strictly true you can fill them all, but it illustrates the theory)

A 'format' is any combination of font type, size, weight, colour, etc. If
you regularly exceed this, then it should be more your design that Excel.

This will be improved with the built in table, pivot, conditional
formatting, as it uses 'styles' (already in earlier versions but few use
them).

Is it 'fixed'...don't now, but really shouldn't care either.


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
G

Guest

Nick,
There are many reasons, and I quite frankly didn't plan on it or try to. I
have to use exact formats provided by different vendors and governmental
agencies. Tax returns, official filings etc. The government, state, and
regulatory agencies do not permit any change from their formats including
fonts. I incorporate them into my templates using auditing tools, formula's
etc. That way I can build formulas to automate numerous processes in one
workbook. I frequently ran out of columns. I also made macros to further
automate. I'm obviously not the only one that has this problem because it is
a FAQ. I'm also not the smartest person to ever use excel! I made some of my
own problems, but I am not permitted to change the other people's fonts. I
just don't incorporate them in the same workbook anymore. Thanks for your
response!
 
N

Nick Hodge

I'll try and find out, but still not convinced Excel is the correct tool and
that these different inputs should not be in separate files then.

Let you know

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
G

Guest

Nick,

Thanks-and you have to understand you are probably correct, I'm just not
that bright!
Thanks again

Jim
 
G

Guest

Nick,

Thanks a million-I wish I could get a response from Microsoft. Thanks again!

Jim
 
G

Guest

Thanks Nick-I appreciate that. I went to Microsoft website and I couldn't
find anything on this in Office 2007. Thank you and Microsoft. It's a great
product. No response necessary-I realize you are very busy.

Jim
 
N

Nick Hodge

Jim

I'm not busy...lazy Saturday afternoon...sunshine, Wimbledon and world cup!

Glad you got your answer anyhow...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error: Too many different cell formats 2
Excel 2007 1
View more than 1 spreadsheet at a time in Excel? 5
EXCEL macros running much more slowly in EXCEL 2007 vs. 2003 1
Why can't I get more than 255 characters in one cell in Excel 07? 1
Saving Excel 2007 file in 2003 creates very large file 2
how do i get more than three conditional formats in excel 1
Help for Excel users who hit "Too many different cell formats" 2

Top