Multi Users on Shared workbook

[callsidd]

Hi everyone,

Hope all is well.

I have a database where atleastt 5 users work simultenously on a shared worksheet.

How can we fix issues (not responding, missing entries, data corruption, hang up) being faced by multi-users while updating an excel file? On an average, there are six to seven thousand entries are being done on monthly basis.

Can anyone help me out please?

Regards,

 

[dmt32]

Hi,
Probably not too helpful but I think you will find that the general consensus of opinion on this board is to avoid shared workbooks.

You can read more here:http://blog.contextures.com/archives/2008/11/18/avoiding-shared-workbooks-in-excel/

Dave

 

[callsidd]

Thanks

Hi,
Probably not too helpful but I think you will find that the general consensus of opinion on this board is to avoid shared workbooks.

You can read more here:http://blog.contextures.com/archives/2008/11/18/avoiding-shared-workbooks-in-excel/

Dave

 

[Smitty]

With that many entries, I'd seriously consider using Access. It's set up to be a multi-user environment.

Or you can use Excel online, which does support co-authoring.

 

[callsidd]

Thanks I understand Acess can cater this requirement but unable to build that

With that many entries, I'd seriously consider using Access. It's set up to be a multi-user environment.

Or you can use Excel online, which does support co-authoring.