Multiple users using macro-enabled workbook

[tiredofit]

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

 

[Logit]

"Is it possible for an excel macro-enabled workbook, saved in Dropbox to be accessed by multiple users at the same time?"
No.

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? No Workbook must be closed first.

Situation 2. If user A SAVES it but leaves it opened, can user B open that workbook? No Workbook must be closed first.

In Situation 1. IF user B CAN open the workbook, what value will be in cell A1? User B can open the workbook if it was closed first when B got there. If A saved the workbook after changing A1,
A1 will be 2.

In Situation 2. IF user B CAN open the workbook, what value will be in cell A1? User B can open the workbook if it was closed first when B got there. If A saved the workbook after changing A1,
A1 will be 2.

I understand that multiple users can access the same workbook but in "Read Only Status". Meaning, no changes to the workbook can be effected.

 

[tiredofit]

"Is it possible for an excel macro-enabled workbook, saved in Dropbox to be accessed by multiple users at the same time?"
No.

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? No Workbook must be closed first.

Situation 2. If user A SAVES it but leaves it opened, can user B open that workbook? No Workbook must be closed first.

In Situation 1. IF user B CAN open the workbook, what value will be in cell A1? User B can open the workbook if it was closed first when B got there. If A saved the workbook after changing A1,
A1 will be 2.

In Situation 2. IF user B CAN open the workbook, what value will be in cell A1? User B can open the workbook if it was closed first when B got there. If A saved the workbook after changing A1,
A1 will be 2.

I understand that multiple users can access the same workbook but in "Read Only Status". Meaning, no changes to the workbook can be effected.

Thanks for your detailed reply.

What's your advice for someone who insists on sharing workbooks in Excel? Activate the legacy Share Workbook functionality?

 

[Logit]

Use something else as your 'back-end' and implement the Excel worksheets for your convenience.
Or ... go with another software completely.

 

[tiredofit]

Use something else as your 'back-end' and implement the Excel worksheets for your convenience.
Or ... go with another software completely.

Thanks