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
|