Multiple computers

  • Thread starter Thread starter tippy
  • Start date Start date
T

tippy

One excel workbook with many users. At the moment, only one user can
make input at a time on a common drive. Certain cells are password
protected as is the workbook itself.

What is the best way of setting it up so that multiple users can input
to it at one time. The users are only interested in making input to
their respective sheet. The information is input into individual
sheets for and by each user, then consolidated into another worksheet.
_____________

Tippy
 
How will "share" work differently? I'll check out the function but
perhaps someone can tell me how it would/should work better than just
using a common drive. Will users be able to make entries in different
worksheets at the same time?

What are pros and cons?

Tippy
 
Harald,

I read the sites and find them most helpful. I suppose that once I
share them, I'll need to turn off sharing when I make monthly changes
to the worksheets. This looks good.

Hi Tippy

You need a common drive anyway. But sharing means that it can take input
from multiple users simoultaneously. It will however not be "live" as a
database woul be. See

http://www.techonthenet.com/excel/questions/shared.htm
http://www.microsoft.com/office/ork/030/030.htm#ORK030C2
Click to expand...

_____________

Tippy
 
I tried using share but found that the spreadsheet would either save my
changes or the other person's.
We created a spreadsheet that has a spin button (we call it a clicker).
The object is to put the spreadsheet on a few computers, as staff
answers patron's questions (we're a library) they click the spin button
to increment a counter. At the end of the day, they put the total into
a spreadsheet. However, sharing the workbook does not dynamically show
the total incrementing by both PCs. Each PC only sees their own
counter incrementing...it doesn't combine the totol from both PCs.
 
I tried using share but found that the spreadsheet would either save my
changes or the other person's.
We created a spreadsheet that has a spin button (we call it a clicker).
The object is to put the spreadsheet on a few computers, as staff
answers patron's questions (we're a library) they click the spin button
to increment a counter. At the end of the day, they put the total into
a spreadsheet. However, sharing the workbook does not dynamically show
the total incrementing by both PCs. Each PC only sees their own
counter incrementing...it doesn't combine the totol from both PCs.
Click to expand...


Well--it seems to work for me.

I have 4 separate workbooks on a common drive but each workbook is in
a separate folder. Each workbook is used by 4 to 12 people. In each
workbook, one person is assigned a specific worksheet. Although they
can post wrongly in the other worksheets, they have no reason to do
so. My tests showed that 3 simultaneous users of one workbook, each
using a different worksheet, showed that all entries were saved
properly. The individually assigned worksheets contain data entries
that are consolidated via formulas in another worksheet in the same
workbook. Eventually, the consolidate information is manually entered
into an Excel MIS. Perhaps someday I'll link them.


By using the "shared" method that Harald Staff suggested, the
difference is that no one has to wait at critical times to make
entries. I appreciated the help.

Excel has replaced an ACCESS data base that was so complicated and
secure that it was ineffective and inefficient. Using the KISS
principle, things are working better.
_____________

Tippy
 
Back
Top