View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?