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
456 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
How to record audio from input sources to your PC – connected devices, connected preamp to record vinyl discs, streaming media, that play through your audio card: Vista, Windows 7, Windows 8, Windows 8.1 and Windows 10 – both 32 bit & 64.
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

739 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