Solved

Excel Not opening file from mapped drive.

Posted on 2014-03-10
7
1,483 Views
Last Modified: 2014-03-14
I am trying to open Excel files from Excel 2010.  I browse to a mapped drive but when I open it appears no files are there. It will open files from remembered paths using this method.  If I go go straight to the mapped drive and double click the Excel document it opens just fine.
0
Comment
Question by:aduvall
[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
  • 3
  • 2
  • 2
7 Comments
 
LVL 6

Expert Comment

by:c1nmo
ID: 39918222
Does the folder have xls files and excel 2010 is looking for xlsx in the open file filter?
0
 

Author Comment

by:aduvall
ID: 39918235
Nothing appears no matter what I select.  I tried "All files" but nothing.
0
 
LVL 6

Expert Comment

by:c1nmo
ID: 39918300
How about if you copy the share path and filename into the file open box, when you click open does it find the file ok?
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:aduvall
ID: 39918354
Yes it does.
0
 
LVL 95

Accepted Solution

by:
John Hurst earned 500 total points
ID: 39918369
Given that you have tried the above steps, now try doing an Office 2010 Repair. Go to Control Panel, Programs and Features, click on Office, Change and then Repair.

After the repair is complete, restart and test again.
0
 
LVL 6

Expert Comment

by:c1nmo
ID: 39918393
And if you replace the filename in the box with *.* and click open do the files show up?
0
 
LVL 95

Expert Comment

by:John Hurst
ID: 39930059
@aduvall - Thank you and I was happy to help.
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
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…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

738 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