I recently got excel 2007. All my macros and vlook up's do not work in excel
2007. Is there an easy fix to this problem. I have 1000's of files that I use
daily that this effects.
=VLOOKUP($C$1,'\\warren-file\engineering\Starbucks\[Starbucks Shipping
Schedule.xls]SHIPPING'!$D$15:$Y$600,2,0)

This is one of my vlookup that work in excel 2003 but not in excel 2007.
How do I make this work?
Thanks

XL 2007's default setting is for macros to be disabled. You have to
explicitly tell XL to enable macros.

I don't have XL 2007 in front of me, so this may be a little inaccurate:
click the new office icon in the upper left hand corner, navigate to XL
options, and look for the security-related settings.

Enable macros.

(You also will probably want to choose to have the developer ribbon shown.)

Dave
--
Brevity is the soul of wit.


"dpal" wrote:

I recently got excel 2007. All my macros and vlook up's do not work in excel
2007. Is there an easy fix to this problem. I have 1000's of files that I use
daily that this effects.
=VLOOKUP($C$1,'\\warren-file\engineering\Starbucks\[Starbucks Shipping
Schedule.xls]SHIPPING'!$D$15:$Y$600,2,0)

This is one of my vlookup that work in excel 2003 but not in excel 2007.
How do I make this work?
Thanks

Thanks but I couldn't find that. I ended up going to the New icon and to
excel otions and then to addins. From there you pick vlook up and add it in
and microsoft will update your computer to be able to use it.

dpal

"Dave F" wrote:

XL 2007's default setting is for macros to be disabled. You have to
explicitly tell XL to enable macros.

I don't have XL 2007 in front of me, so this may be a little inaccurate:
click the new office icon in the upper left hand corner, navigate to XL
options, and look for the security-related settings.

Enable macros.

(You also will probably want to choose to have the developer ribbon shown.)

Dave
--
Brevity is the soul of wit.


"dpal" wrote:

I recently got excel 2007. All my macros and vlook up's do not work in excel
2007. Is there an easy fix to this problem. I have 1000's of files that I use
daily that this effects.
=VLOOKUP($C$1,'\\warren-file\engineering\Starbucks\[Starbucks Shipping
Schedule.xls]SHIPPING'!$D$15:$Y$600,2,0)

This is one of my vlookup that work in excel 2003 but not in excel 2007.
How do I make this work?
Thanks