tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,834
- Office Version
- 365
- 2019
- Platform
- Windows
Simple question:
Is it possible for an excel macro-enabled workbook, saved in Dropbox to be accessed by multiple users at the same time?
I have a macro-enabled workbook called Master.xlsm, saved in Dropbox.
Suppose user A opens the workbook, changes cell A1 from 1 to 2.
Situation 1. If user A DOES NOT save it but leaves it opened, can user B open that workbook?
Situation 2. If user A SAVES it but leaves it opened, can user B open that workbook?
In Situation 1. IF user B CAN open the workbook, what value will be in cell A1?
In Situation 2. IF user B CAN open the workbook, what value will be in cell A1?
Obviously the question extends to the situation of running the code.
Thanks
Is it possible for an excel macro-enabled workbook, saved in Dropbox to be accessed by multiple users at the same time?
I have a macro-enabled workbook called Master.xlsm, saved in Dropbox.
Suppose user A opens the workbook, changes cell A1 from 1 to 2.
Situation 1. If user A DOES NOT save it but leaves it opened, can user B open that workbook?
Situation 2. If user A SAVES it but leaves it opened, can user B open that workbook?
In Situation 1. IF user B CAN open the workbook, what value will be in cell A1?
In Situation 2. IF user B CAN open the workbook, what value will be in cell A1?
Obviously the question extends to the situation of running the code.
Thanks