Sharepoint document editing

I have a basic question about Sharepoint.  We have 2010..and a very very very simple site with just a few excel documents on it.  We have about a 2-3 people who have the rights to edit and a few others who can just view.

Bottom line is this- we dont want to have to do the whole checkout/download/edit/upload/checkin process when we need to edit one of these documents.  There is very little risk that any editing would be happening at the same time between those 2-3 users.  Also- on the excel docs, we do have the 'allow changes by more than one user at the same time' check box checked on the Review Tab > Share Workbook setting in Excel.

Is the checkout/download/edit/upload/checkin  process a mandatory thing?  We fully understand the need for it in certain cases, just not something as simple as ours.

Please help me find a way to simplify this,,, I have a project team frustrated and we have been told we must use this sharepoint site for this activity.

Thanks! - Jacob
snyperjAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jamie McAllister MVPSharePoint ConsultantCommented:
You can turn these options off easily in Library Settings.

Go go Library Settings then go to Versioning settings. You can turn off Content Approval, Checkin/out, and change versioning settings there.

Screenshot here;

http://blogs.technet.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-00-66-12/3058.Versioning.png
snyperjAuthor Commented:
Ok, so we changed the settings so they match the screen shot below.  However, when we click on an excel document in the 'Shared Docs' library we are  prompted if we want to save or open it ...we choose open.  It opens in ' Ptotected Mode' and says the file originated from the internet and might be unsafe.  It gives us a button to 'Enable Editing'.  We click it and it changes to [Read-Only].?

On the othe hand.  if we place a check in the checkbox next to the excel document in the Shared Docs library and then click 'edit' up in the ribbon  under the 'open and check out' section...we are prompted to login to the site again and it will not take our credentials.  Ugh frustrated!library
snyperjAuthor Commented:
Any additional ideas based on the last posting?  Sorry to be a nudge but kind of desperate...
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

Jamie McAllister MVPSharePoint ConsultantCommented:
This is a common issue, with several possible causes, though most likely browser settings.

Try this guidance first; http://sharepoint.stackexchange.com/questions/58215/excel-links-open-files-as-read-only-mode-how-to-change-this-to-edit-mode

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jamie McAllister MVPSharePoint ConsultantCommented:
snyperjAuthor Commented:
Thanks...good info...doesn't answer why we get the secondary login box when clicking 'edit in excel'...but it helps.  We are thinking we are going to lobby to use dropbox instead!!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.