How to refresh the content in Shared Workbook ?
 

Dear All,

I would like to ask if two users open a shared workbook at the same time,
one of them saves the workbook, how can other user read the updated data
immediatedly?

For Example:

User A & B: open the shared workbook at the same time
User A & B: can only read 10 rows data in sheet1 of this workbook
User A: add one row in sheet1 and then save the workbook
User B: Can user B read the 11th row data immediatedly without reopen this
workbook? (because in my case, User B can't read the 11th row data unless he
close and reopen this workbook)

Can I use VBA marco for this task ?

Thank you for all