Excel - Excel 2007 Shared Workbook

Asked By Nadine

15-Dec-09 01:26 PM

Running Vista Enterprise, Office 2007

Excel 2007 - sharing a workbook
file saved to a network drive.
File worked with no problems in 2003 on XP

Users open file make changes and try to save - receives errors:
either - File is Locked
or
a sharing violation. Please close the document and try to open it again."

Changes done by current or other users are not getting saved
Even though it says it is been saved if reopen changes are not there.

15-Dec-09 01:37 PM

Various thoughts come to mind.

Are users accessing a shared file or have they copied it to their personal
drive.  Is the file showing as a shared file.

Simple things but matters I have encountered with shared documents on a
common drive.

15-Dec-09 03:35 PM

Shared worbook - using the share workbook functiions under the Review Tab,
Saved on shared network drive, same permissions to both.