from 2003 to 2007

[Guest]

I have 2003 workbook with several macros. When I open it first time in 2007
all works fine. When I am saving it it prompts me to save it with macros
enables. When I try to reopen the saved file it takes about 10 minutes. Why ?
How I should save the file to make reopening process as smooth as opening
2003 file ?

Thanks for advise.

Tony

 

[Jim Rech]

When I try to reopen the saved file it takes about 10 minutes

If you are doing this reopening via a double-click in Explorer or a shortcut
be aware that many people have reported similar very slow openings. This
seems to be a problem we can hope MS will repair in the first service patch
of Excel 2007 but, until then, you'd do better to open Excel and then open
the workbook via the menus.

--
Jim
|I have 2003 workbook with several macros. When I open it first time in 2007
| all works fine. When I am saving it it prompts me to save it with macros
| enables. When I try to reopen the saved file it takes about 10 minutes.
Why ?
| How I should save the file to make reopening process as smooth as opening
| 2003 file ?
|
| Thanks for advise.
|
| Tony

 

[Gary Keramidas]

a lot of things are slower in 2007. one example, i have a macro that summarizes
12 sheets into a table. in 2003, less than a second. in 2007 3 or 4 seconds. i
don't have an answer.

 

[vlad0wnzj00]

a lot of things are slower in2007. one example, i have a macro that summarizes
12 sheets into a table. in 2003, less than a second. in20073 or 4 seconds. i
don't have an answer.

Gary, the only answer I found, is to go back to Office 2003.
Unfortunate, since I think that the new features and UI are great, but
the fact that it is a few orders of magnitude slower than 2003 is
unacceptable to me.