Excel provides a feature to share excel workbook or excel file between multiple users. Sharing excel file enables us to simultaneously work on a single excel file which can’t be done otherwise. Shared workbook solves the problem of exception thrown by excel ie. File locked for editing by ‘another user’. To share your excel file > Go to Tools > Share Workbook. In Share Workbook, click on Editing Tab > Select Allow changes by more than on user…. checkbox. Then click on Ok [...]
Home » Posts tagged "allow editing by more than one user at the same time"