![]() |
#2
|
|||
|
|||
![]()
I'm afraid your problem will be, that when user opens Excel workbook, and makes any changes in it, the Excel this user is working with is a copy of workbook in memory of user's computer (or e.g. in memory of some Terminal Server). The changes are saved to real workbook only when the workbook is saved. And any VBA code is running in memory in system and instance, the this particular user is working from.
And when several users are trying to force the save their own instances of same workbook practically at same time ... ![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel VBA Loop to update formula in certain cells and create copy in new workbook off dynamic range | bwosk | Excel Programming | 1 | 10-07-2021 10:36 AM |
Excel 2010 - Shared Workbook greyed out | osheac3*40 | Excel | 0 | 03-08-2016 11:40 PM |
OneDrive + iPhone Excel: Cannot Update Workbook? | markg2 | Excel | 0 | 12-07-2014 09:02 AM |
Shared Excel workbook | eguru2 | Excel | 0 | 07-12-2011 12:02 AM |