How to make excel rows/columns writable by only specific people

130 pts.
Tags:
Excel 2003
NTFS permissions
Spreadsheets
I have two users working on the same spreadsheet, both should be able to write to only their specific part of spreadsheet, i.e. user2 should not be able to overwrite what user1 has previously entered. I know NTFS permissions, will operate on the file level, but I guess I'm looking to restrict it to a row/column level. I thinks I could use something like "protect sheet" but not sure if applicable as it seem to apply to a whole sheet? Any ideas on how to approach this? Many thanks

Software/Hardware used:
Excel 2003
ASKED: March 9, 2010  9:49 PM
UPDATED: March 11, 2010  4:10 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

I suggest you only allow them access to 1 sheet each in a separate workbook, and then consolidate the entries on a sheet in a 3rd workbook. (This method can be expanded to add extra sheets in the book if input from more users becomes necessary.)

By that i mean, user 1 enters into book1/sheet-user 1, and book2/sheet-user2 is used for the 2nd user. How much space on each sheet is upto your requirements. (you can do the normal restrictions then for each book.)

Then to show each user entries on the same sheet, paste the links to the columns on a sheet in a common read only book.

Not knowing exactly how you are intending to use the data entered, this solution might seem vague. I am hoping it might be enough to give you a nudge to ward the solution you are looking for.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denwood
    I agree with Chippy088. Having two independent spreadsheets will be the best/easiest solution. A third spreadsheet would have formulas that would link to these independent spreadsheets. If the file name and location does not change, the information from the independent spreadsheets will automatically insert the information into the third.
    390 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following