Solved

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

Posted on 2013-01-16
3
1,055 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_
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
schaps earned 500 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

New My Cloud Pro Series - organize everything!

With space to keep virtually everything, the My Cloud Pro Series offers your team the network storage to edit, save and share production files from anywhere with an internet connection. Compatible with both Mac and PC, you're able to protect your content regardless of OS.

Question has a verified solution.

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

How can this article save you time AND money?  In just a few minutes you may discover something you didn't know existed that is easy enough for you to fix yourself!
Do you come here a lot? Are you lazy like me and don't want to go through the "trouble" of having to click your Dock's Safari icon and then having to click your Experts Exchange Favorites bookmark to get here? Well then this article is for you.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

920 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

17 Experts available now in Live!

Get 1:1 Help Now