Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
version differences in excel 2007 - use of macros & range names
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
version differences in excel 2007 - use of macros & range names
If we could see the code, it would surely help. Might even be of some help
if we knew what the named ranges were referring to. As for the Student/Home version; check your macro security settings. Tools -- Macro -- Security and set it to "Medium" (disable with alerts which permits you to enable them). You'll have to close Excel and re-open it for the new setting to take effect. "difinity" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save an Excel 97-2003 version or 2007 version for Mac 200 | Excel Discussion (Misc queries) | |||
Excel 2007 not saving user-created range names | Excel Discussion (Misc queries) | |||
Excel Macros - Any Major Differences Between 2003 and 2007 | Excel Worksheet Functions | |||
Excel 2007 version differences | Excel Discussion (Misc queries) | |||
Insertion of *Objects* Into Spreadsheets (Version Differences) | Excel Discussion (Misc queries) |