Tech Support Forum banner

"cannot access" error when opening excel doc over network

3752 Views 2 Replies 2 Participants Last post by  breakfastsface
ok here's the deal...

There is an excel document on a server running microsoft server 2003.
There is a windows machine
There is a mac.

If I am writing to the excel sheet on the windows machine then I can open the excel sheet as read-only on the Mac... this is fine and to be expected of course.

If I am writing to the excel sheet on the Mac and I try to open the excel sheet on the windows machine i cannot even open it as read only... instead I get the error- "Cannot Access: filename.xls"

I only want to be able to read the excel sheet on a windows machine while it is open with write access on the mac.

The docs in question open fine on either machine when they are not in use by the other.


This issue reproduces with all flavors of Win Xp Pro and Vista and with OS X 10.4 and 10.5... it reproduces on many different machines, with every excel and/or word doc I've tried... but only Microsoft Office docs.

On Windows we're using Microsoft Office 2007... on Mac we've used Microsoft Office X and Microsoft Office for Mac 2008.

The Microsoft "personal support" service was unable to resolve this issue and they want to elevate to the "pro support" level,... but I'm trying to do some research elsewhere before dropping so much cash on this small inconvenience.

big thanks if you can help!
Not open for further replies.
1 - 3 of 3 Posts
In order to have the file open in more than one location at a time, it has to be a shared file. Otherwise you get the error that you cannot open. Look up Share Workbook in Excel help for the steps to do this in your version of Excel.
One thing to keep in mind, while the workbook is shared, major edits to Macros, VB, and other items are not able to be done. You would have to un-share the workbook, make the major changes then share again.

Good Luck.
good-great-grand-wonderful,... that solves it.

...funny how MS Support couldn't even manage this one!

hats off! :pray:
1 - 3 of 3 Posts
Not open for further replies.