SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In our company from time to time there are polls (like 'Name, Employee number, Will you attend the christmas party? Dinner preference?' ... ) which are typically handled via Excel sheets shared in a MS Sharepoint. The problem is that quite often one user or the other destroys the excel sheet, e.g. by sorting a single column, and in the end this workflow still causes a lot of work and trouble.

My question is if there is a safer way of letting people only edit one line in an excel sheet or automated gathering of information into excel sheets with standard tools which can be used in an intranet.

share|improve this question

migrated from Jan 15 '13 at 7:19

This question came from our site for computer enthusiasts and power users.

up vote 2 down vote accepted

Have you considered using a standard SharePoint List with a form either in SharePoint or using InfoPath?

THis allows you to lock down the list, and also allows you to set the protection on the list to only allow the users access to their own data.

Once completed the data can then be exported to Excel to manage the final results.

Pro Tip: Do some research around SharePoint lists and how they work.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.