ok, here goes. I have a shared workbook that is going to be accessed by another workbook which always opens read only. Users of the R/O workbook will hit a macro button located within it and what then happens is the shared workbook is opened, a specific cell within it will be changed, the shared workbook saved and then closed. However, every user doing this will be saving to a different cell.
All this happens in VBA code very quickly.
The question I have is about how excel saves to a shared workbook.
I know that when it's actually saving, excel locks the shared workbook until the save action is finished. That's a not a problem to deal with, I can just put in code that while .fileislocked = true to wait. However, what I need to know is exactly what is saved when a user opens a shared workbook, changes 1 cell and saves it. Does Excel save the entire workbook or does it just save that cell?
The workbook will be accessed by around 30 people at the same time, saving single cell changes to it around every 2 minutes (each).
I also know that in the shared workbook options I can have an option to either have a dialog box appear when two users try to save to the same cell, or just have the changes being saved overwriting whatever is there. That also shouldn't be an issue as no two users will ever write to the same cell at the same time in the setup I have, it'll always be different cells.
However.....because I'm not keeping the shared workbook open all the time on each users PC I need to know how the save event works. Is it possible that two users could open the shared workbook at the same time, one of them saves data to a cell and a split second later the other one saves to a different cell.....will the second save overwrite the change to the first cell?
The options in shared workbooks kind of imply that it won't.....for example, the option of seeing changes other people have made when you save. But it doesn't state it explicitly, therefore before I implement this way of doing things I'd like to know if it will actually work or if I need to think of something else.
I hope I've made this clear enough, it's causing my poor, tired brain to overheat.
Bookmarks