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
442 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 91

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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

744 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now