Shared drive issue - saving file in access through excel

[xtr3m3dud3]

Hello All,

I have around ~100 users who are divided into 5 batches, they work on spreadsheet that has been shared on a network. My BIGGEST challenge is that since it is a shared spreadsheet it often leads to crashing or some or the other error popping up when opening the file.

I somewhere read that this can be tackled by saving the data in Access which will be at the backend while users work on Excel. This will also help me in not having to collate data from different spreadsheets that I am doing now.

Really looking forward to a solution to this........thanks a ton in advance to all here.

 

[Derek Brown]

I have always avoided Shared Workbooks because they have too many limitations and can easily become corrupted.
See also the text and comments at http://blog.contextures.com/archives/2008/11/18/avoiding-shared-workbooks-in-excel/
I would normally go for an Access back-end database with an Access and/or Excel front-end. For Excel, you could use VBA (ADO or DAO) to read and update the database records.