How can i allow multiple pushes of data to a single shared workbook?
Posted on 2011-10-26
* Office 2007 *
Good Afternoon All,
The Project was to have multiple workbooks (lets call these StartBooks) for different areas of the business showing similar metrics, and these would be rolled up to a single document that holds aspects of the originals along with a lot of information from around the business (Lets call this FinishBook).
Creating all of those was fine; however an issue came about when those using the StartBooks tried to push their updates at the same time.
My users where receiving a couple of messages, however they were all based on the same issue of file is read only, the err details are
Desc: <File Name> is read-only. To save a copy, click OK, then give the workbook a new name in the Save As dialog box
Is there something that I’m missing with regards to multiple users trying to push their data to a single shared Workbook?
The Pushing of data works fine if only one person is doing it from their StartBooks; it also works perfectly if there is someone in the FinishBook viewing it. The error only happens if multiple users push their data at the same time.
Any suggestions would be greatly appreciated, and if there should be any questions about this please do not hesitate to ask.