Multiple users working on the same xlsm

ttitto · December 12th, 2008, 01:20 PM

I have an excel database with VBA-code. The data must be filled in the xlsm-file from 4 different PCs. My question is if it is possible two users to open and edit the same xlsm-file located on a server. All PCs have Microsoft Office 2007 Enterprise.

ExcelExpertUK · January 4th, 2009, 10:57 PM

Dear Ttitto,

How are your users connecting to and opening your VBA Excel 2007 .xlsm file ?
If they are opening the file directly over an office network or LAN , only one person may open the file at one time for reading AND writing. Once a user opens the file it becomes locked to other users allowing them to open it for 'read' purposes only.
When the first user is done with the file and closes it, the 'write' lock is released allowing once again another user to open it for writing.

If you'd like for multiple users to be able to write to the file simultaneously you might want to look at giving users access to the file through a web interface or even via Excel which connects to a central excel file (or better still to a proper database application) using ADO.

I hope this answers your question,

Regards,

Jake

courtesy of
www.Excel-Expert.co.uk

www.OfficeSoftworks.co.uk, www.Macro-Expert.co.uk www.MSExcelExpert.com