excel

Hi experts,
I have a question about excel and am not really good at excel.  I have a form that sent to me from email. I save the form in to the computer.  the form that I save I need to enter the amount on the fields but when I tried to enter, it gave me the message that the excel is ready only.  I check the properties of the excel form, it did not check read only.  where else I can check so that I can do the entry.

Thanks
urjudoAsked:
Who is Participating?
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.

Danny ChildIT ManagerCommented:
I'd do a Save As on the file as you've opened it from email, and save it to your My Documents (or similar) location.

This may change the [Read Only] status so that you can change it.

When you return it, you'll need to add it as a new attachment to the email, of course!
0
Danny ChildIT ManagerCommented:
If that doesn't work out, can you attach the file here, and then we can take a look?
0
Zac HarrisSystems Administrator Commented:
This means that the author of the excel sheet has file permissions on the sheet to prevent certain editing from occuring. If you do a SaveAs and change the name ( you can simply add a "1" or whatever to the end) that will allow you to save a copy you can then edit.
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

urjudoAuthor Commented:
I tried both suggestion.  it still not working and gave me a message "the cell or chart that you are trying to change is protect and there fore ready-only. to modify a protected cell or chart, first removed protecting using the unprotect sheet command (review tab, changes group), you may be prompted for a password".  so that means I need a password from the sender, is correct?
0
Danny ChildIT ManagerCommented:
Yes it would, but there would normally be certain cells on the sheet that were Unprotected, where you could enter the values that were expected of you.  You may want to ask the sender where these are.

It's normally done to protect complex or sensitive areas from being accidentally overwritten.  
An example might be on an employee timesheet where they could enter the hours worked, but not change their hourly rate.

Can you attach the sheet so we can examine it further?
0

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
urjudoAuthor Commented:
I will ask sender for the password.
0
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 Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.