Excel 2007 slow to open spreadsheets from Explorer


G

Guest

I use Office 2007 on various OS's.

Trying to open Excel 2003 or 2007 documents in Excel07 from Windows Explorer
takes 1 full minute. Opening Excel 2007 first then clicking the Office
Button | Open | then choosing a spreadsheet opens immediately.

How can you make Office2007 open spreadsheets from Explorer faster??

I checked and this is already un-checked "Ignore other applicatins that use
DDE".

Lots of posts asked how to fix this in Excel2007 when un-checking
"Ignore..." does not work but I couldn't find any answers. Anyone know?
Thank you!!
 
Ad

Advertisements

G

Guest

you should get used to opening files within program. Otherwise you could
save multiple copies of same file all over the place. If you open them
within program the program remembers the directory where you originally had
the file and just overwrites with the save.
 
P

Peo Sjoblom

While it might be a good practice using file>open that is not an explanation
why it takes such a long time just by opening a file from windows explorer.
It shouldn't be any difference and I assume it wasn't when the OP used
previous versions of Excel.


--


Regards,


Peo Sjoblom
 
G

Guest

right, the spreadsheets in Explorer open immediately in Excel 2003 but not
2007.

I also implemented Martin von Gagern's solution of editing the File Type
"Open" association of .xls, .xlsx, etc but none of those worked. I'm
currently on a Windows 2003 Server box, perhaps the File Type association
settings (i.e. "%1") etc. should be different for 2003 server than in
Martin's instructions? I'll try those on an XP box. I apologize if you
haven't seen his instructions, they are posted in lots of posts here.
 
G

Guest

Resolved! turns out I was not implementing Martin's solution to ALL of the
various .xls, .xlsm, .csv file extensions so once I did that for all those
file types, (since I was testing all of them!! no wonder it failed on a .csv
when I had previously only fixed it for type .xls) now all of my various
Excel files open quickly, from Windows Explorer.

Thanks to everyone for your time & advice on this one. Peo have you tried
the solution below, how did it go?

Here are Martin's instructions from another post. Instead of leaving the /e
I removed that and replaced it with just the "%1", as others had done too...

Subject: Re: Excel 2007 very slow to open even the simplest worksheet
4/16/2007 5:56 AM PST

By: Martin von Gagern In: microsoft.public.excel.misc


Does http://martin.von-gagern.net/howtos/excel2007load help?
I wrote about this in another thread here, but I know many people only
monitor their own thread. Sorry for the duplicate to everyone else.
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?
 
G

Guest

i'm afraid this didn't work for me - after the change when i closed either an
xls or xlsx i would get an error saying the file i just had open couldn't be
found. it was a bogus error of course, but annoying as it was there every
time. used the regedit to change back but had to reset xls back to office
excel 2007 file association in win explorer- somehow it dropped that
association - its a very odd bug tho and very annoying. i can hardly wait for
my 1000 users to start complaining once this software is pushed out.

i've since pinned the app to start menu as i have access since 2003 and it
does work much faster so think i'll just stick with that rather than plan on
doing edits on every single pc in my network. ugh. the thought of it just
makes me cringe.
 
Ad

Advertisements

G

Guest

I had the same experience on my 2003 Server where when you close a .xls it
errors saying the file you just opened couldn't be found. So I too used
regedit to change it back and so forth.

But then I added the "%1" back on because you may have noticed this too, if
you leave the Excel document open for a minimum of 7 seconds or more and THEN
try to close it, you won't get the error. Does that work on yours?
Hopefully soon we'll all know what's causing the "file you just opened
couldn't be found" type of error so we can truly fix that as well, in an
environment that has Martin's solution applied.
 
Ad

Advertisements

D

Dizzle

i'm afraid this didn't work for me - after the change when i closed either an
xls or xlsx i would get an error saying the file i just had open couldn't be
found. it was a bogus error of course, but annoying as it was there every
time. used the regedit to change back but had to reset xls back to officeexcel2007file association in winexplorer- somehow it dropped that
association - its a very odd bug tho and very annoying. i can hardly wait for
my 1000 users to start complaining once this software is pushed out.

i've since pinned the app to start menu as i have access since 2003 and it
does work much faster so think i'll just stick with that rather than plan on
doing edits on every single pc in my network. ugh. the thought of it just
makes me cringe.

All- I have had the same issue as stated above. In attempts to solve
the issue, I tried all the proposed solutions above, and they did not
work in my case. What finally solved this issue was:

Click on Start -> Search -> Files and Folders -> All Files and Folders

(make sure you are searching for hidden files and folders as well by
checking the search hidden files and folders check box under More
Advanced options)

Search for personal.xls.

Open Personal.xls from the search results window.

In excel, click on the view tab, and click Unhide

Save your personal.xls file by clicking the office button -> Save

Close out of excel completely.

Open Personal.xls again, click the view tab, then click hide, then
save personal.xls, then exit excel.


Now you should be able to open any excel file from a windows explorer
window with out any issue.
 

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