A
andy_suffers_Excel_2003_over-engineering
I'm an experienced Excel user - I've recently upgraded machine, which has
meant upgrading from Excel 2000 to Excel 2003.
I use the VLOOKUP commands *a lot* with my job.
I see that Excel 2003 now has the option to use Text labels (e.g "Sales",
etc) instead of cell references (e.g $A$3).
I only ever use Cell references, because I find it easier to work with,
easier to spot if something goes wrong, etc.
Since upgrading to Excel 2003, VLOOKUPS have started failing to work
properly.
Example :
=VLOOKUP($D6,[Book2]Sheet1!$D$7:$G$11,2,
I can get as far into the formula as this...but when I want to type "FALSE)"
and hit enter, I get a dialogue box open up saying "Identify Label".
When I click on the 'X' to close this dialogue box, Excel promptly crashes
- every single time.
What's more, I've note been able to find a means of turning off this damned
"Identify Label" function.
It's a classic case of "If it aint broken - Don't fix it !".
Anyone have any tips on how I can permanently turn this annoying new
function off, I'd be very grateful..
Thanks,
Andy.
meant upgrading from Excel 2000 to Excel 2003.
I use the VLOOKUP commands *a lot* with my job.
I see that Excel 2003 now has the option to use Text labels (e.g "Sales",
etc) instead of cell references (e.g $A$3).
I only ever use Cell references, because I find it easier to work with,
easier to spot if something goes wrong, etc.
Since upgrading to Excel 2003, VLOOKUPS have started failing to work
properly.
Example :
=VLOOKUP($D6,[Book2]Sheet1!$D$7:$G$11,2,
I can get as far into the formula as this...but when I want to type "FALSE)"
and hit enter, I get a dialogue box open up saying "Identify Label".
When I click on the 'X' to close this dialogue box, Excel promptly crashes
- every single time.
What's more, I've note been able to find a means of turning off this damned
"Identify Label" function.
It's a classic case of "If it aint broken - Don't fix it !".
Anyone have any tips on how I can permanently turn this annoying new
function off, I'd be very grateful..
Thanks,
Andy.