At SAP, we regularly have spreadsheets that several people are expected to access and update. Usually, this update is supposed to be completed by a certain date, and as there are many people like myself who are total procrastinators, the spreadsheet opens up as “Read Only” – big bummer because that means I have to work late again to get this task done on time!
A colleague shared something incredibly useful with me the other day. It is very easy to set a spreadsheet to being shared. This means that Excel will keep track of changes, even if several people have it open, and Excel will synchronize them to the degree possible upon saving.
To do this, simply follow these steps:
Go to “Tools” on the menu bar, then to “Share Workbook”.
Simply set the flag for allowing changes by more than one user at a time.
Next time you open the spreadsheet, you will see the “[Shared]” in the header bar. If another colleague opens this spreadsheet now, they can also work on it.
My hope is that you didn’t know this either, and I can help you in your work.
Then again…maybe I am the only XLS-unenlightened one out there! 🙂