У нас есть лист Excel, который должен редактироваться несколькими пользователями одновременно. Я попытался сделать это с помощью функции совместного использования, но она всегда отображает сообщение только для чтения, когда кто-то другой пытается открыть лист одновременно.
Есть ли обходной путь или у вас есть другие идеи?
Руководящие принципы нашей компании очень строги, практически невозможно что-либо установить или изменить что-либо в архитектуре системы / сервера.
This seems more like a management/IT Ops issue than a technical one for you to try and resolve.
If you must - I suggest you open the excel file in googledocs or something (presuming it is within your companies guidelines). And collab like that.
If that isn't an option. I suggest both you and your colleague both modify your own read only copies of the file - then use the 'merge' feature to try and interlace them best you can.
Sadly office 2010 isn't fantastic for collab work out of the box.
EDIT: If you are unable to use the built-in sharing functionality then an option might be to hold the data in a separate container (can be database tables, a JET (Access) database or even CSVs) and then have a read-only Excel file that interfaces with the data.
The advantages of this are ease of use for end-users as they retain the familiar design and UI of Excel and the abstraction of the data away from the front-end means no problems with concurrency and the data itself it can be better protected from unintended updates (validation etc. in front-end).
The disadvantage is that this requires a fair bit of set up (although you mention you're using VBA already so may have the skills to hand) and may only be appropriate in certain use cases.
Original answer: You can make it a Shared Workbook but be aware this does bring a few caveats and quirks relating to specific functionality and overall stability/robustness.
There are horror stories out there of locking, concurrency and data loss problems with shared workbooks, but in many cases they can work very well. I've personally used them with up to 20-odd concurrent users and if managed correctly and, critically, designed with collaborative working in mind, then they can work very well.