Stump the Panel » End Users and Information Workers

Cannot use workbook sharing

(4 posts)

  1. juggle12
    Member

    Using MOSS 2007/Office 2007
    I know its by design (http://office.microsoft.com/en-us/excel/HA100898961033.aspx) but I'm looking for a clever workaround anyway. You can't publish a shared workbook and you can't publish a workbook with external links. Normally I'd have 20 account managers open up the same shared workbook and work on it all day, simultaneously. Now in SharePoint (ironically named) you cannot "share" in this way. Check out > edit > save/check in only.

    So the question is, do I force them to change the way they work, or is there a way to merge changes in a shared workbook they way everyone has for 10+ years? Never mind the problem with external links in a workbook. That's a real head-scratcher.

    Posted 2 days ago #

  2. AutoSponge
    Administrator

    Not everything belongs in SharePoint. I'd let them work the way they always have--off the fileshare.

    Posted 1 day ago #

  3. laura67
    Moderator

    You're right that not everything belongs in SharePoint. Here's an option, though (if the spreadsheet isn't too complex).
    Create a custom list in SharePoint, and have them use the list instead of a spreadsheet. This will support *some* formulas. What do the external links go to?

    Laura Rogers
    http://spinsiders.com

    Posted 21 hours ago #

  4. juggle12
    Member

    The links are to other reports, mostly excel or PDF on a file share. The volume is much too large to pull into SharePoint (10K+) because we have our own document tagging taxonomy. I would have to hire a couple of temp workers and it just wouldn't be worth it, so those resources remain on the share.

    The group wants to drink the SharePoint cool-aid, but with their shared workbook system projects would end up split between two locations. What I've had to do is let them upload the workbook into a library and teach them all to only check out and edit when they actually have some data to add. That way they leave the document available to others. With external links I've gone around and disabled the excel "update relative links" option which was automatically converting shared drive links to SharePoint relative links. (very naughty)

    Thanks for your replies.

    Posted 21 hours ago #

RSS feed for this topic

Reply

You must log in to post.