Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 slow to open spreadsheets from Explorer
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!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 slow to open spreadsheets from Explorer
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!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 slow to open spreadsheets from Explorer
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!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 slow to open spreadsheets from Explorer
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!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 slow to open spreadsheets from Explorer
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!! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 slow to open spreadsheets from Explorer
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!! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 slow to open spreadsheets from Explorer
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. "ethelhusky" wrote: 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!! |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 slow to open spreadsheets from Explorer
On Nov 8 2007, 10:51 am, ethelhusky
wrote: 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. "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 Excelfiles open quickly, fromWindowsExplorer. 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: Excel2007very slow to open even the simplest worksheet 4/16/20075:56 AM PST By: Martin von Gagern In: microsoft.public.excel.misc Doeshttp://martin.von-gagern.net/howtos/excel2007loadhelp? 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 andExcel2007takes anywhere from 30 to 60 seconds to open these worksheets. I am running WindowsXP 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 inExploreropen immediately inExcel2003 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 aWindows2003 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 fromwindowsexplorer. It shouldn't be any difference and I assume it wasn't when the OP used previous versions ofExcel. -- 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 Office2007on various OS's. Trying to openExcel2003 or2007documents in Excel07 fromWindows Explorer takes 1 full minute. OpeningExcel2007first then clicking the Office Button | Open | then choosing a spreadsheet opens immediately. How can you make Office2007 open spreadsheets fromExplorerfaster?? 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!! 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
documents very slow to open in excel 2007 | Excel Discussion (Misc queries) | |||
Opening Excel spreadsheets via explorer - issues in Excel 2007 ? | Setting up and Configuration of Excel | |||
Excel 2007 - Can't open xls files from Explorer | Excel Discussion (Misc queries) | |||
Excel 2007 doesn't open files selected using Explorer or Recent Do | Excel Discussion (Misc queries) | |||
Excel Slow to open Spread Sheet from Explorer | Excel Discussion (Misc queries) |