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
458 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

630 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