ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   worksheet on network (https://www.excelbanter.com/excel-discussion-misc-queries/135146-worksheet-network.html)

Jan

worksheet on network
 
i have a small office with 7 employees and all the employees have separate
computers and they are connected through networking. we have a stock list
and the stock list is updated almost every hour. the problem i have is this
that 2 employees can not update the file at the same time if one is updating
the other can only view. so is there any solution for this so that 2
employees can update the file at the same time.

Vergel Adriano

worksheet on network
 
You can set the workbook as a shared workbook by going to Tools-Share
Workbook.

There are limitations to a shared workbook. But you might want to explore
it to see if it fits your needs. Search the help file for "shared workbook
limitations" to see which features are unavailable in shared workbooks.



"jan" wrote:

i have a small office with 7 employees and all the employees have separate
computers and they are connected through networking. we have a stock list
and the stock list is updated almost every hour. the problem i have is this
that 2 employees can not update the file at the same time if one is updating
the other can only view. so is there any solution for this so that 2
employees can update the file at the same time.



All times are GMT +1. The time now is 05:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com