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.
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?
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.