Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 313
Default from 2003 to 2007

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default from 2003 to 2007

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default from 2003 to 2007

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default from 2003 to 2007

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel opens two windows (2007 & 2003 format): I want only 2003. Rob Excel Discussion (Misc queries) 0 March 6th 10 07:46 PM
Excel 2003 help doesn't work. I got both Excel 2003 and 2007 insta Kenneth Andersen Excel Discussion (Misc queries) 0 February 16th 10 10:44 AM
Saving from 2007 to 2003 - 2003 won't open the file James Piper Excel Discussion (Misc queries) 0 February 2nd 10 02:56 PM
Why can't I sort a 2003 file in 2007? 2007 freezes. lw2007 Excel Discussion (Misc queries) 0 April 27th 09 07:41 PM
2007 & 2003 - Default open with 2003 JudithJubilee Excel Discussion (Misc queries) 4 June 6th 08 04:18 PM


All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"