Excel 2007 very slow to open even the simplest worksheet

R

RobN

Martin,

Thanks for your reply.

I changed the line "C:\Program Files\Microsoft Office\Office12\Excel.EXE" /e
"%1" to "C:\Program Files\Microsoft Office\Office12\Winword.EXE" /e "%1" .

Then, double clicking the shortcut to the excel file, opened Word, but
strangely, it tried to open the Excel file which of course it couldn't.
Anyway, I changed it back again and amazingly, the file now opens straight
away!

I won't say it's fixed for good but is working for now.

Thanks again,

Rob

Martin von Gagern said:
Hi Rob!

Did I get this right, that Excel is slow to start again after a while,
even though the fix still seems to be in place, i.e. the dialog still
shows the described modification?

You should check whether the command you edit is the command that gets
executed. Change it to something else entirely, e.g. Edit.exe or some
such. If it still opens Excel, then it's executing some other command,
but if it opens the other program but after changing back opening Excel
is still slow, then Excel became slow to open files given on the command
line as well.

If Excel is executing some different command, then you could look for
other file associations. Excel 2007 has quite a few formats, and while I
only described XLS, it might be that some of them use different
settings, and that your doubleclick triggerd one of these others.

If you suspect Excel is starting slow for command line arguments as
well, you might try to enter the whole command, with the actual file
name instead of %1, into a command line window. If that is slow as well,
then Microsoft really broke something even more, otherwise it might also
be Explorer being slow to decide whether Excel is running or not.

In any case, it would be interesting what kind of action makes the
system slow again. I suspect it could be some kind of automatic update.

Generally all of you should probably complain to your vendor or some
official Microsoft support contact if you can. My fix is a workaround,
for those annoyed enough to search and lucky enough to find help. A real
fix would be for everyone, distributed by Microsoft. So let them know
there is a problem.

Greetings,
Martin von Gagern
Martin,

I too used your method, which worked well for a time, but now, it
doesn't.

If I repair Office and/or completely uninstall and reinstall and make
the
same changes of adding the "%1" and [rem see command line], to the
appropriate sections to the relevant file types, the problem is fixed
again.
BUT the problem doesn't stay fixed!!! After a while, the same slow
opening
of the file occurs when trying to open it from a shortcut if Excel is not
already open.
The unusual occurrence of double clicking an Excel shortcut, then
minimizing
the Excel program also once used to be a fix, as Excel would
automatically
maximize again and open the file. However, that doesn't even work any
more
as the file is no longer being opened by that procedure.

Anything else to try?

Rob
 
M

marriouk

Will this work for Word (.doc)?






- Show quoted text -


All,

these are the registry changes if you want to write it into a simple
batch file - one for .xls and one for .xlsx:

[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command]
@="\"H:\\Program Files\\Microsoft Office\\Office12\\EXCEL.EXE\" /e
\"%1\""

[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command]
@="\"H:\\Program Files\\Microsoft Office\\Office12\\EXCEL.EXE\" /e \"1%
\""

If you are working on a big network you could add this to a login
script to deploy it to everyone at once.

Here's hoping MS come up with a proper solution soon.

m.
 
R

Roger

Tried to follow your suggestion. Step #6 Button Advanced does not exist.

My problem
Current performance of Excel 2007 under WinXP 2GB Ram 1.8Ghz cpu
vs Excel 2003 under Vista 2GB ram 1.8 Ghz cpu
In both cases I had the file on my desktop and no other programs were running

Open the file by dble click

Excel 07 22 sec
Excel 03 11 sec including click on warning to enable macros

Change the value of a single cell to 566
Worksheet FID IRS
Cell G12

Excel 03 <1 sec
Excel 07 Gave up after two minutes.
Attempted to close Excell which caused crash of program

Bottom line Excell 2007 appears not to be out of Beta.
 
C

chetan.kataria2010

I have worksheets that only have from 1 to 7 rows and Excel 2007 takes
anywhere from 30 to 60 seconds to open these worksheets. I am running
Windows XP SP2
on a IBM/Lenova with 1 Gig of ram and a 3 Ghz processor.

Is there any setting I can change (or turn off) to speed this muther up?

hi
first copy all copy and open new file right click paste special
ok
 

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

Top