I have a large workbook in excel 2003 which uses an embedded lookup macro to
report certain data by date. works well.
I now need to run this workbook in excel 2007, and have some problems.
- I get the range label error, although all ranges are defined names. -
lookup is across multiple ranges, either as a vlookup, or as and
'intersection' between defined range names.

- If I try to run it in my Student/Home version (at home), the macro will
not load or run. If I run it in the Enterprise version (at work), it runs
though slowly. If I run it in Office Mac2008, it won't run at all. Why do I
get a difference in the 2007 functionality?
thanks