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

T

TimK

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?
 
G

Gord Dibben

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
 
T

TimK

This didn't happen with Excel in Windows XP

Gord Dibben said:
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
Click to expand...
 
B

Bernie Deitrick

This didn't happen with Excel in Windows XP
Click to expand...

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

HTH,
Bernie
MS Excel MVP
 

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

F2 - NO color-coded precedents??? 2
double click cell to show formula references 1
Unable to replace cell references with Named ranges 0
Excel 2003 with Reference error cause me a headache 0
My Mouse scroll doesn't work with excel 2007 - Jim Rech 1
Excel 2003 & 2007 formula compatibility 0
NAME error in excel 2010 0
Unable to copy formula from one cell into 2 or more consecutive ce 2

Top