Hello,
I have a semi simple taske. We want to be able to share an excel spreadsheet that will be used as a schedule for all of our conference rooms in our building The biggest concern we have is people making changes to the schedule at the same time. If there is a better way to organize and schedule a conference room please advise.
I know with excel your can use the shared workbook feature. The only problem that I noticed is that:
Two Users open the file at same time - User (A) & User (B)
User (B) Makes changes to the spreadsheet and saves
User (A) will not see those changes until they Save the document.
This can be a problem for example is one user opens the schedule sees an open slot but does not reserve the timeslot and save the file for an extended period, this means that user is viewing outdated data and by the time they actualy save/reserve that spot it may already be taken. Having realtime data would solve this.
Basicly I was wondering if there is a way to make a vba script that can either update the spreadsheet every 2 seconds, or save the file every two seconds... It appears that when a users saves the spreadsheet any changes from another user are shown then...
Please advise
I have a semi simple taske. We want to be able to share an excel spreadsheet that will be used as a schedule for all of our conference rooms in our building The biggest concern we have is people making changes to the schedule at the same time. If there is a better way to organize and schedule a conference room please advise.
I know with excel your can use the shared workbook feature. The only problem that I noticed is that:
Two Users open the file at same time - User (A) & User (B)
User (B) Makes changes to the spreadsheet and saves
User (A) will not see those changes until they Save the document.
This can be a problem for example is one user opens the schedule sees an open slot but does not reserve the timeslot and save the file for an extended period, this means that user is viewing outdated data and by the time they actualy save/reserve that spot it may already be taken. Having realtime data would solve this.
Basicly I was wondering if there is a way to make a vba script that can either update the spreadsheet every 2 seconds, or save the file every two seconds... It appears that when a users saves the spreadsheet any changes from another user are shown then...
Please advise