ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2003 hangs when trying to locate a workbook to open (https://www.excelbanter.com/excel-discussion-misc-queries/19025-excel-2003-hangs-when-trying-locate-workbook-open.html)

Darren Hill via OfficeKB.com

Excel 2003 hangs when trying to locate a workbook to open
 
When I try to open a workbook located in another folder I usually go File
Open and then use the Open window to change folders and locate the file
workbook I wish to open but the moment I try change folders Excel hangs /
freezes. I using Xp Professional SP2 / Office 2003 and has been updated
with the latest updates.

--
Message posted via http://www.officekb.com

Dave Peterson

Are you sure excel is locking up?

I've found that excel can slow down while it's getting the list of drives or the
list of files if there's too many.

If you map a lot of drives, maybe you can disconnect some (yech!).

But if you have lots of files in the folders, maybe you can reorganize by
creating more subfolders and put some of the files in separate subfolders.

"Darren Hill via OfficeKB.com" wrote:

When I try to open a workbook located in another folder I usually go File
Open and then use the Open window to change folders and locate the file
workbook I wish to open but the moment I try change folders Excel hangs /
freezes. I using Xp Professional SP2 / Office 2003 and has been updated
with the latest updates.

--
Message posted via http://www.officekb.com


--

Dave Peterson


All times are GMT +1. The time now is 10:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com