Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel 2011 on Mac can't open files on windows file server

Posted on 2013-01-16
3
Medium Priority
?
1,156 Views
Last Modified: 2013-02-21
Hi Experts,

One of my users has a new error that just started appearing. He's on a new Macbook Pro with Office 2011 installed. One of our file servers is a Windows Server 2003 server. Just yesterday his Mac was able to open, view, and edit excel docs that were saved on that server. Now, when trying to open the Excel doc from his Mac he gets an error saying the file is not found. It's clearly there but the Mac won't open it in Excel. Our PCs open the files just fine in Excel 2010.

What could have changed?

Thanks!
0
Comment
Question by:telstar_
[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
3 Comments
 
LVL 10

Accepted Solution

by:
schaps earned 2000 total points
ID: 38824666
Can he copy the file to his Mac and then open it? Can he create and save an Excel file to the share? If so, can he then open it from the Mac?

I suspect it's a permissions issue on the server, but your answers to the above will help narrow it down.
0
 

Author Comment

by:telstar_
ID: 38856663
Yes, he can copy it to his computer and open it just fine. He's able to create and save an excel file to the share. He's also able to then open the file.

I'm thinking now it has to do with ODBC as the file he's having trouble opening relies on data from that connection. I'm going to adjust the ODBC connection settings on his Mac and see if that helps but if you have other ideas please don't hesitate to share them.
0
 

Author Comment

by:telstar_
ID: 38916840
Just learned that his "new" Mac had been restored through Time Machine before it ever got to me using a backup that was created in Snow Leopard. This backup was applied to a Mountain Lion machine and therefore there were all kinds of issues due to the differences in the two versions of the OS.

Thanks for the assistance. Turned out it was a major permissions error that was not just localized to Excel as many more issues showed up very quickly afterwards.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Article by: Justin
In light of the WannaCry ransomware attack that affected millions of Windows machines, you might wonder if your Mac needs protecting. Yes, it does and here is how to do it.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

670 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