Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 "Tony" wrote in message ... |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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. -- Gary "Tony" wrote in message ... 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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Aug 1, 4:29 pm, "Gary Keramidas" <GKeramidasATmsn.com wrote:
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel opens two windows (2007 & 2003 format): I want only 2003. | Excel Discussion (Misc queries) | |||
Excel 2003 help doesn't work. I got both Excel 2003 and 2007 insta | Excel Discussion (Misc queries) | |||
Saving from 2007 to 2003 - 2003 won't open the file | Excel Discussion (Misc queries) | |||
Why can't I sort a 2003 file in 2007? 2007 freezes. | Excel Discussion (Misc queries) | |||
2007 & 2003 - Default open with 2003 | Excel Discussion (Misc queries) |