By references I mean instead of worksheet and cell referencing, in Access would be referencing tables/queries and fields and textboxes.

Multiple users cannot simultaneously open and edit same Excel file.