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

[jimbcpa]

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?

 

[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)

 

[jimbcpa]

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!

 

[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)

 

[jimbcpa]

Nick,

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

Jim

 

[Nick Hodge]

Jim

Feedback is the limit is increased to 64000 in 2007

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

 

[jimbcpa]

Nick,

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

Jim

 

[Nick Hodge]

Jim

That is from MS

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

 

[jimbcpa]

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

 

[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)