Create a Shared Workspace
Excel calls workbooks shared through SharePoint shared workspaces or sometimes shared lists. The Excel documentation isnât always careful about it, but there is a difference:
Shared workspaces are entire documents stored on SharePoint.
Shared lists are parts of documents stored on SharePoint.
How you share those two things is different, so, first-things-first, letâs talk about shared workspaces.
Note
Shared workspaces are a big improvement over shared workbooksâExcelâs earlier feature that allowed multiple users to share edits. For one thing, workspaces provide tools to manage a workbookâs users or send out notices to those users.
How to do it
Once youâve signed up for a trial SharePoint site or installed SharePoint on your own server, youâll have an address (also know as a URL) for your site. Write that down. My SharePoint URLs are:
- //excelnotebook.sharepointsite.com
For my trial site from Apptix. This is available to me over the Web from anywhere.
- //wombat1
For my local site on my local server. This is the URL I use for accessing the server from my local, home network.
- //65.11.195.07 (not my real IP address for security reasons)
For my local server over the Web. This is the IP address my Internet provider assigned me, and I havenât bothered to associate it with a domain name since I donât expose that server to the public very often.
I can use any of those URLs to share a workbook, though //wombat1/ is the quickest since it goes ...
Get Excel 2003 Programming: A Developer's Notebook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.