ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel workbook to be used by multiple users at same time....possible??? (https://www.excelbanter.com/excel-worksheet-functions/32365-excel-workbook-used-multiple-users-same-time-possible.html)

malik641

Excel workbook to be used by multiple users at same time....possible???
 

I have to make a workbook that keeps track of inventory of samples under
certain study numbers which are delt with in one department and then
another and so on and so forth.

My question is, since this workbook will be used by multiple users most
likely at the same time....will excel allow this to happen?? Or will it
give an error message "Cannot read file, it is being used by another
program" or whatever??


--
malik641
------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=381938


roly


Hi Malik,

You can't have full access for multiple users in Excel.

However, you can using an Access database, except that you can't edit
the same record together, which doesn't happen that much.

Much of what Excel does Access can do - its very versatile.

All the best,


Roly


--
roly
------------------------------------------------------------------------
roly's Profile: http://www.excelforum.com/member.php...o&userid=24631
View this thread: http://www.excelforum.com/showthread...hreadid=381938



All times are GMT +1. The time now is 02:58 PM.

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