Excel 2007 Why So Slow?

G

Guest

Excel 2007. Since upgrading to Office 2007 from Office 2003 I have noticed a
marked delay in opening my Excel workbooks. The workbook in question has
modules that run on open. In Office 2003 the workbook main sheet came up
right away. Now in 2007 Excel acts like it has opened nothing (blank window)
and remains that way for up to 30 seconds before actually displaying my
workbook's main sheet. THEN it starts executing (ever so slowly) the startup
VBA module. Why is this "new and improved" product so slow in loading my
workbbok and SLOW in completing the startup code? Thanks for any help.

P.S. I am experiencing the same slowness with Word 2007 and Outlook 2007.
 
J

Jim Rech

I've found that every version of Excel is slower than the previous and Excel
2007 sets a new standard. However I haven't seen anything akin to your
experience. I'd say 'something is going on' but no idea what. Btw, do you
get the same delayed opening if you open a workbook from Excel's File, Open
versus double-clicking a link to the file?

--
Jim
| Excel 2007. Since upgrading to Office 2007 from Office 2003 I have
noticed a
| marked delay in opening my Excel workbooks. The workbook in question has
| modules that run on open. In Office 2003 the workbook main sheet came up
| right away. Now in 2007 Excel acts like it has opened nothing (blank
window)
| and remains that way for up to 30 seconds before actually displaying my
| workbook's main sheet. THEN it starts executing (ever so slowly) the
startup
| VBA module. Why is this "new and improved" product so slow in loading my
| workbbok and SLOW in completing the startup code? Thanks for any help.
|
| P.S. I am experiencing the same slowness with Word 2007 and Outlook 2007.
| --
| Dr. Doug Pruiett
| Good News Jail & Prison Ministry
| www.goodnewsjail.org
 
G

Guest

512MB of RAM is not a lot to be using Office 2007. 1gb is probably a minimum.

Dave
 
G

Guest

I think this is a RAM issue. The OP says he has 512Mb of RAM which seems too
little for Office 2007.

I run XL 2007 on a dual core processor with 2gb of RAM and still
occasionally see slow response times.
 
J

Jim Rech

I have 512mb too and haven't run into a slow opening issue. That doesn't
mean it is not his issue, say if he has a huge workbook. But, absent that,
I suspect something else is going on.

--
Jim
|I think this is a RAM issue. The OP says he has 512Mb of RAM which seems
too
| little for Office 2007.
|
| I run XL 2007 on a dual core processor with 2gb of RAM and still
| occasionally see slow response times.
| --
| A hint to posters: Specific, detailed questions are more likely to be
| answered than questions that provide no detail about your problem.
|
|
| "Jim Rech" wrote:
|
| > I've found that every version of Excel is slower than the previous and
Excel
| > 2007 sets a new standard. However I haven't seen anything akin to your
| > experience. I'd say 'something is going on' but no idea what. Btw, do
you
| > get the same delayed opening if you open a workbook from Excel's File,
Open
| > versus double-clicking a link to the file?
| >
| > --
| > Jim
message
| > | > | Excel 2007. Since upgrading to Office 2007 from Office 2003 I have
| > noticed a
| > | marked delay in opening my Excel workbooks. The workbook in question
has
| > | modules that run on open. In Office 2003 the workbook main sheet came
up
| > | right away. Now in 2007 Excel acts like it has opened nothing (blank
| > window)
| > | and remains that way for up to 30 seconds before actually displaying
my
| > | workbook's main sheet. THEN it starts executing (ever so slowly) the
| > startup
| > | VBA module. Why is this "new and improved" product so slow in loading
my
| > | workbbok and SLOW in completing the startup code? Thanks for any
help.
| > |
| > | P.S. I am experiencing the same slowness with Word 2007 and Outlook
2007.
| > | --
| > | Dr. Doug Pruiett
| > | Good News Jail & Prison Ministry
| > | www.goodnewsjail.org
| >
| >
| >
 
G

Guest

I had a similar problem. A relatively simple spreadsheet would take 30
seconds or more to open when opening by double-clicking the file - that's on
a 3.1 Ghz P4 with 1.5GB. Don't know if the circumstances are the same or
not, but I had an old Acrobat PDFMaker 6.0 installed. I unstalled the entire
Acrobat 6, then when I'd try opening the spreadsheet it would give me
"Compile error in hidden module: AutoExecNew", and it would give me "Compile
error in hidden module: DistMon" when I'd close. Tried repair on Office 2007
- same thing. Then I deleted the leftover file "C:\Program Files\Microsoft
Office\Office12\XLSTART\PDFMaker.xla". After that,, I stopped experiencing
the delays on load as well as the error messages.
 
G

Guest

I have the same problem. I have 1GB memory and the spreadsheet uses only one
sheet and occupies no more than one screen full. I have no virus scan and the
spreadsheet an take up to a minute to load. During the loading time it says
"Ready" at the bottom of the screen. Ready my eye !
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Saving Autorecover info in 2007 so SLOW! 2
Excel 2007 Forms 2
Maximum number of charts--Excel 2007? 1
version differences in excel 2007 - use of macros & range names 1
Excel 2007, why is it slow opening files created in Excel 2003? 1
Excel 2003 Formula Error 2
Urgent: Excel 2003 - 2007 conflict! 4
Embedding an Excel 2007 worksheet into an email without attaching 2

Top