Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


excel datasource question

Posted on 2012-08-28
Medium Priority
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
  • 2
LVL 13

Accepted Solution

Ryan earned 2000 total points
ID: 38340578
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.

Author Comment

ID: 38341130
anyone out there know how to accomplish what I described in my question?

Author Comment

ID: 38356473
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

580 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