Hi we have few staff that sharing same Microsoft Excel Worksheet, at same time, and they need to search, edit(Update). is there any way to make such rules? currently if A user open other unable to edit or update.
Hi we have few staff that sharing same Microsoft Excel Worksheet, at same time, and they need to search, edit(Update). is there any way to make such rules? currently if A user open other unable to edit or update.
... and that is a good thing.
Excel does not support simultaneous access by multiple users very well. Although there are settings to share a workbook, so several users can edit and change data at the same time, these shared workbooks tend to become corrupt, lose data, act funny and are impossible to troubleshoot.
If you need a true multi-user solution, consider a database with a front end, like Access, SharePoint, MySQL, etc.
cheers,
Thank you very much teylyn, we use excel to cut cost
You can share the workbook. Click on Review>Share Workbook>under editing tab check the box which reads"Allow changes by more than one user at the same time. This also allows workbook merging.".
Now your workbook can be edited by multiple user.
WARNING: Sharing might corrupt the workbook.!!!!!!!!!!!!!!!!!!!!
@preond, I think I already said that above. No need to repeat what's already been posted.
@rashim
That's fine. But the most cost effective solution is not necessarily the best solution, i.e., it does not mean that Excel will do what you need to be done, just because you don't have to spend money to use it. If you have Excel, you probably also have Access. Access does support multiple users at the same time, so you may want to design a solution that iswe use excel to cut cost
- cost efficient (because you already own the licenses)
- keeps your data intact (which an Excel shared workbook will not do)
- is much more flexible with regards to user privileges
- can be queried by multiple users at the same time using reports or an Excel front-end for viewing data.
Access is not always available, I've worked for companies that had Excel but not Access. It is worth checking though because multi-user Excel will probably end in problems as Teylyn says
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
some things to consider:
1 how many users at once
and often this will happen (20 users occasionally accessing is not really a problem but 20 users using it constantly would be)
2,layout
see attached
3. user education
they must save before entering if they are likely to overwrite cells used by others and always accept changes by others(make sure the ask me selection option is changed)
4 housekeeping
you will need to monitor the sharing to make sure users are not logged in multiple times.
periodically make sure everyone has closed and saved then unshare reshare the work book
keep an unshared back up copy yourself once a day or more regularly
5. if things go wrong stop every one using the shared workbook.
get each of them to save /as a local copy so you can cross check data.
unshare workbook if you can, then reshare and get everyone one at a time to re enter their data.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
my company only have excel, we don't have access, due to Policy , currently we only have 5 user that use same file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks