Spreadsheet collaboration
Well, I've been working with Cathy D. and Rachel this morning, helping them design a way to have both of them doing data input for an excel spreadsheet of unplaced orders that Sherrie wants. I thought about an Access database, but that seemed like overkill (though with such a limited amount of data - title, author, requestor, dept, cost - it would have been easy to set up), so in the end they are working on separate spreadsheets, and we'll merge the data into one workbook at the end.
Woah Nellie! That paragraph above... that was BEFORE I searched Excel/Office Help. Where I discovered that we can:
Share a workbook
- Create a workbook you want to make available for multiuser editing, and enter any data you want to provide.
- If you want to include any of the following features, add them now: merged cells, conditional formats, data validation, charts, pictures, objects including drawing objects, hyperlinks, scenarios, outlines, subtotals, data tables, PivotTable reports, workbook and worksheet protection, and macros. You can't make changes to these features after you share the workbook.
- On the Tools menu, click Share Workbook, and then click the Editing tab.
- Select the Allow changes by more than one user at the same time check box, and then click OK.
- When prompted, save the workbook.
- On the File menu, click Save As, and then save the workbook on a network location accessible to the intended users. Use a shared network folder, not a Web server.
- Check any links to other workbooks or documents, and fix any that are broken.
All users with access to the network share have full access to the shared workbook (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.), unless you use the Protect Sheet command (Tools menu, Protection submenu) to restrict access.
The users who will edit the shared workbook need Microsoft Excel 97 or later (Microsoft Windows) or Excel 98 or later (Macintosh).
Well that's pretty cool. Cathy and I tested it out (we're both on Office 2003). Rachel will have a go later this morning (she's on Office 2000).

0 Comments:
Post a Comment
Links to this post:
Create a Link
<< Home