Excel 2003 cell references - 32 refs - no more highlighting?
 

I just got upgraded to Vista and Excel 2003, however one fluke has appeared.
If I reference more than 32 cells within a formula and I hit F2 to edit the
formula, I lose the (previously known) highlighting function, i.e., prior to
this, all the referenced cells would be higlighted in different colors.
Is there some new option I have to select to enable this?

Excel 2003 cell references - 32 refs - no more highlighting?
 

Has nothing to do with upgrading.

Excel has a 30 argument limit so anything over that won't be highlighted.


Gord Dibben MS Excel MVP

On Tue, 30 Jun 2009 07:04:02 -0700, TimK
wrote:

I just got upgraded to Vista and Excel 2003, however one fluke has appeared.
If I reference more than 32 cells within a formula and I hit F2 to edit the
formula, I lose the (previously known) highlighting function, i.e., prior to
this, all the referenced cells would be higlighted in different colors.
Is there some new option I have to select to enable this?

Excel 2003 cell references - 32 refs - no more highlighting?
 

This didn't happen with Excel in Windows XP

"Gord Dibben" wrote:

Has nothing to do with upgrading.

Excel has a 30 argument limit so anything over that won't be highlighted.


Gord Dibben MS Excel MVP

On Tue, 30 Jun 2009 07:04:02 -0700, TimK
wrote:

I just got upgraded to Vista and Excel 2003, however one fluke has appeared.
If I reference more than 32 cells within a formula and I hit F2 to edit the
formula, I lose the (previously known) highlighting function, i.e., prior to
this, all the referenced cells would be higlighted in different colors.
Is there some new option I have to select to enable this?

Excel 2003 cell references - 32 refs - no more highlighting?
 

This didn't happen with Excel in Windows XP

Actually, it deos. I only get highlights for 32 references in Excel 2003 under Windows XP.

HTH,
Bernie
MS Excel MVP

Excel 2003 cell references - 32 refs - no more highlighting?
 

Yes it did.

After 32(not 30) as I stated.


Gord

On Tue, 30 Jun 2009 09:09:02 -0700, TimK
wrote:

This didn't happen with Excel in Windows XP

"Gord Dibben" wrote:

Has nothing to do with upgrading.

Excel has a 30 argument limit so anything over that won't be highlighted.


Gord Dibben MS Excel MVP

On Tue, 30 Jun 2009 07:04:02 -0700, TimK
wrote:

I just got upgraded to Vista and Excel 2003, however one fluke has appeared.
If I reference more than 32 cells within a formula and I hit F2 to edit the
formula, I lose the (previously known) highlighting function, i.e., prior to
this, all the referenced cells would be higlighted in different colors.
Is there some new option I have to select to enable this?