excel datasource question

Posted on 2012-08-28
Last Modified: 2012-08-31
At the moment we can share basic spreadsheets on the office lan and 2 people can edit simultaneously, all works fine but....

We have one spreadsheet that has been converted from a range to a table and it needs to be that way.  When it is converted to a table we loose the ability to share editing access with the other user.  Is it possible to create a sheet that is editible by 2 people in the office like have done already, and use this sheet as the datasource that updates the table converted spreadsheet?

The goal is to have a spreadsheet (range type) editable by more than one person in office via sharing and this file serves as the datasource for the table type sheet which cannot be edited by more than one person.  Hopefullly this makes sense.

Win 7 64 & Excel 2010
Question by:tf2012
    LVL 13

    Accepted Solution

    You're verging on the need for a database.

    I avoid shared spreadsheets since Office first started it, and it corrupted too many of my files. Another expert is likely to disagree and tell you what you're asking. My work around for it is any of the following.
    1)Google Docs (simultaneous editing showing live edits), but not very powerful in terms of graphing and VBA. It can be queried though.
    2)Shared file on a network, but only allow 1 person to edit at a time. Cons are only 1 edit at a time, and they have to remember to close it or they lock people out.
    3)Shared file off network, and sync'd by another program like Dropbox. Again only 1 edit at a time, but Dropbox will notify you when it's updated, and also manage revisions.
    4)use a database to store data, generating forms in Access or query them into Excel as needed.
    LVL 1

    Author Comment

    anyone out there know how to accomplish what I described in my question?
    LVL 1

    Author Comment

    I've requested that this question be closed as follows:

    Accepted answer: 0 points for tf2012's comment #a38341130

    for the following reason:

    guess not

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now