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!!

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.
--
suesea


"ksmek" wrote:

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!!

While it might be a good practice using fileopen 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


"Suesea" wrote in message
...
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.
--
suesea


"ksmek" wrote:

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!!

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.

"Peo Sjoblom" wrote:

While it might be a good practice using fileopen 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


"Suesea" wrote in message
...
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.
--
suesea


"ksmek" wrote:

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!!

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: 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.

John wrote:
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?




"ksmek" wrote:

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.

"Peo Sjoblom" wrote:

While it might be a good practice using fileopen 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


"Suesea" wrote in message
...
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.
--
suesea


"ksmek" wrote:

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!!

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.

"ksmek" wrote:

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: 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.

John wrote:
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?




"ksmek" wrote:

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.

"Peo Sjoblom" wrote:

While it might be a good practice using fileopen 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


"Suesea" wrote in message
...
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.
--
suesea


"ksmek" wrote:

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!!