MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Share of the excel files

  Asked By: Rufus    Date: Mar 11    Category: MS Office    Views: 939

I have one question in the sharing the excel on the LAN network. I had
shared my excel on the LAN network. However, it is only able to be
access(READ and WRITE) by only one people at a time.If other people
open the excel files it is in READ ONLY modes.
(i) May I know how can I make it to multi people access(READ n WRITE)
at the same time?
(ii)Should I use other method other than excel? Maybe SQL,MS Access or



2 Answers Found

Answer #1    Answered By: Chuong Tran     Answered On: Mar 11

You can convert your workbook to a shared workbook. For complete instructions,
see 'Share a workbook' in Excel's Help. However, there are many limitations to
shared workbooks. Once you make a workbook shared, you can't change any of the
following: merged cells, conditional formats, data validation, charts, pictures,
objects including drawing objects, hyperlinks, scenarios, outlines, subtotals,
data tables, PivotTable reports, workbook and worksheet protection, and macros.

I can't answer your second question  because I don't know anything about your
workbook: what its purpose is, what kind of data is in it, etc.

Answer #2    Answered By: Indie Williams     Answered On: Mar 11

It's difficult to recommend a solution without knowing a LOT more about your

For the first question, let me explain it this way:
Let's say you had a piece of paper in a drawer with three words on it.

One person takes the paper, makes a copy of it, returns the paper to the drawer
and walks away.
A second person takes the paper and makes a copy, returns the original, and
writes a fourth word on the list.

Does the first person see the fourth word? of course not.
Say the second person then takes the original copy and throws it away and
it with HIS modified copy.
The "original" or "master" paper now has 4 words, but they are not (necessarily)
same four words as are on the copy (or copies).

That is the danger with opening shared files. The last person to file his/her
changes wins!
because all the other changes will be discarded!
In most cases, this is not the desired outcome, because it would mean that
everyone but the last person is wasting their time.
That is why MicroSoft (in their infinite wisdom) designed (or at least utilized)
this method  to ensure that only one person at a time  has the authorization to
write to the file.

Now, for what method you SHOULD use depends on what the data is you're
manipulating, and what applications are available. (BTW: SQL is a "language",
not really a place to store things... although SQLServer is a Database Storage,
like Oracle and MSAccess)

Really, if what you're talking about is having two people open the exact same
piece of information, make changes to it and BOTH be able to save their
changes, chances are it's not going to happen. Thousands and thousands of lines
of code have been written to ensure that that DOESN'T happen. What you want to
do is to MANAGE the changes.

It is possible to use Excel as a front-end tool to get to the data (stored in
Access,Oracle, SQLServer, etc)
Before we can recommend an approach, we need to know more about what you're

Didn't find what you were looking for? Find more on Share of the excel files Or get search suggestion and latest updates.