I created an excel form in office 2000. It contains links to other
worksheets and also has macros. Now that I am using office 2007, it runs in
compatability mode and the macros do not work but the links update. If I save
in the macro-enabled mode, the macros work but the links do not auto update.

Is there something I need to enable?