Tue 6 Jan 2009, 16:02Delegate Celia said...
Celia has attended:
Excel Introduction course
EXCEL
If two people need to input data in to one spread sheet at the same time, is there a way to do this? At work it locks us out if there is someone else using the spreadsheet so we have to wait until they are finished?
Wed 7 Jan 2009, 11:18Trainer Simon said...
RE: Sharing workbooks
Hi Celia,
Thank you for your question.
If you have sufficent rights, you can set the spreadsheet as a shared workbook which means multiple people can edit the spreadsheet at the same time.
To set the workbook as shared, follow these instructions:
1. Tools - Share Workbook.
2. Select the Allow changes by more than one user... checkbox.
I hope this answers your question.
Regards
Simon
