Shared documents not being updated and can be edited by 2+ users



I am working on a shared server. We have several excel documents, mostly
created in Office 2003. We are now running 2007. All of the documents open
and if more than one person has a document open, additional users receive a
message saying that the document is locked for editing, so it's read only.
This applies to all excel workbooks except one. This exception is causing
havoc, as only some of the changes are being saved, no one knows who else has
the document open and lots of work is being lost.
Is there a way to change this within the document settings? As I say it only
applies to one document of many that we share.

Shane Devenshire


Although I know this probably won't solve your problem directs,

In support of Karl's comment, here is a pretty complete list of the features
which are lost when you go to Shared Files, as in some cases the workarounds:

Features that are unavailable in shared workbooks

You can access the following features only if you stop sharing the workbook.

You cannot use shared workbooks (shared workbook: A workbook set up to allow
multiple users on a network to view and make changes at the same time. Each
user who saves the workbook sees the changes made by other users.) on Web

Unavailable feature Alternatives
Create lists (list: A series of rows that contains related data or a series
of rows that you designate to function as a datasheet by using the Create
List command.) None
Work with XML data, including: None

Import, refresh, and export XML data
Add, rename, or delete XML maps
Map cells to XML elements
Use the XML source task pane, XML toolbar, or XML commands on the Data menu

Insert or delete blocks of cells You can insert entire rows and columns.
Delete worksheets None
Merge cells or split merged cells None
Add or change conditional formats Existing conditional formats continue to
appear as cell values change, but you can't change these formats or redefine
the conditions.
Add or change data validation Cells continue to be validated when you type
new values, but you can't change existing data validation settings.
Create or change charts or PivotChart reports You can view existing charts
and reports.
Insert or change pictures or other objects You can view existing pictures
and objects.
Insert or change hyperlinks Existing hyperlinks continue to work.
Use drawing tools You can view existing drawings and graphics.
Assign, change, or remove passwords (password: A way to restrict access to a
workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255
letters, numbers, spaces, and symbols. You must type uppercase and lowercase
letters correctly when you set and enter passwords.) Existing passwords
remain in effect.
Protect or unprotect worksheets or the workbook Existing protection remains
in effect.
Create, change, or view scenarios None
Group or outline data You can continue to use existing outlines.
Insert automatic subtotals You can view existing subtotals.
Create data tables (data table: A range of cells that shows the results of
substituting different values in one or more formulas. There are two types of
data tables: one-input tables and two-input tables.) You can view existing
data tables.
Create or change PivotTable reports You can view existing reports.
Write, record, change, view, or assign macros You can run existing macros
that don't access unavailable features. You can record shared workbook
operations into a macro stored in another nonshared workbook.
Add or change Microsoft Excel 4 dialog sheets None
Change or delete array formulas (array formula: A formula that performs
multiple calculations on one or more sets of values, and then returns either
a single result or multiple results. Array formulas are enclosed between
braces { } and are entered by pressing CTRL+SHIFT+ENTER.) Existing array
formulas continue to calculate correctly.
Use a data form to add new data You can use a data form to find a record.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question