Solved

IN excel 2007 when I attempt to open a drive to save or open a file I get a

Posted on 2007-11-23
6
448 Views
Last Modified: 2008-07-03
IN excel 2007 when I attempt to open a drive to save or open a file I get a
message "initializing root folder to display" with a status bar. When
completed I can see the folders but am unable to open any folders. If I can
cancel and repeat, then I do not get this message.
I have seen a few posts saying I should delete maped drives that are not
connected right now. This is a problem as I work on a domain and need access
to these drives. Are there any ideas how to fix this?
0
Comment
Question by:taustinj
  • 2
6 Comments
 
LVL 1

Accepted Solution

by:
adambaz earned 500 total points
ID: 20340880
Open My computer when you are trying to save the file.

By doing this the computer is already aware that the drives are not connected, and will not eat up all the memory trying to do it using Excel's utilities.

Have a go.

Adam
0
 
LVL 1

Expert Comment

by:adambaz
ID: 20340897
If just having it open does not work, actually attempt to open the drive within My Computer so that it registers.

Adam
0
 
LVL 92

Expert Comment

by:nobus
ID: 20342115
you can also repair excel :
from the add/ remove programs section in control panel; select Office>Modify  
0
 

Expert Comment

by:kev26er
ID: 20442955
Open My Computer and verify all shared drives can still be accessed.  More than likely you have a drive mapped that is either no longer valid or you no longer have access to.  Right click on the suspect drive and disconnect.  The behavior will then go away.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question