Any hacks for sharing excel workbook with multiple users?

[RyanTG]

After scouring forums, I have yet to find a solution to sharing an excel workbook without losing several features (Eg: macros, tables etc).

I have built a Customer Relationship Management (CRM) system within excel and have a need to share it with three other users.

Unfortunately, many of the necessary features are not supported in shared workbooks. Any ideas?

 

[Fazza]

hello

What about splitting the application and having Excel files as a front end for users (they can each have their own file without needing to share) and the data in an mdb file?

what do you think?

 

[RyanTG]

hello

What about splitting the application and having Excel files as a front end for users (they can each have their own file without needing to share) and the data in an mdb file?

what do you think?

Thanks for your reply Fazza!

Do you know where I could find a resource to make that happen?

 

[Fazza]

try googling for things like Excel VBA ADO

this helped me in the past Using ADO with Excel files - Xtreme Visual Basic Talk

and there are plenty of links (maybe no longer current) I posted a few dozen posts into this old thread http://www.mrexcel.com/forum/excel-...ting-pivot-table-multiple-sheets-3-print.html