Link to home
Start Free TrialLog in
Avatar of tf2012
tf2012

asked on

excel datasource question

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
ASKER CERTIFIED SOLUTION
Avatar of Ryan
Ryan
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tf2012
tf2012

ASKER

anyone out there know how to accomplish what I described in my question?
Avatar of tf2012

ASKER

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