Excel - Unprotect

Hello,

I have a budget records excel worksheet. Its for my sons soccer team. I have ran out of lines and want to add a bunch more. I cant insert, copy, or even click on the formula column. How can I make it so I can edit this sheet in order to add more lines for the parents and myself to populate and also have the formula keep counting? When I try to copy and paste is says:
The Cell or chart that you are trying to change is protected and therefore read-only.\
To modify a protected cell or chart, first remove the protection using the unprotected sheet command (Review tab, Changes group). You may be promoted for a password.
The only problem is that unprotected sheet icon is grey and I can click it.  Thank you.
WO2015Asked:
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.

JohnBusiness Consultant (Owner)Commented:
Can you delete some lines you could do without to make some working space?
0
WO2015Author Commented:
I cant insert or delete lines.  When I Right click insert is grey and cant be clicked. I need to add more lines in order to add more transactions.
0
JohnBusiness Consultant (Owner)Commented:
Can you copy a range of cells from the problem worksheet to a new worksheet?

You may have to rebuild the worksheet.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

WO2015Author Commented:
When I try to copy and paste is says:
The Cell or chart that you are trying to change is protected and therefore read-only.
To modify a protected cell or chart, first remove the protection using the unprotected sheet command (Review tab, Changes group). You may be promoted for a password.

The only problem is that unprotected sheet icon is grey and I can click it, I cant paste more lines.
0
JohnBusiness Consultant (Owner)Commented:
Is this true when you copy from problem sheet to a NEW, blank worksheet?
0
JohnBusiness Consultant (Owner)Commented:
Also, how many lines, and what version of Excel?  Can you try a newer version of Excel?

Excel 97 supports 64,000 rows, and newer versions support over a million rows.
0
WO2015Author Commented:
It will not let me copy the header, formula column, or footer. Which I need all of those. I cant copy all, I cant add anything additional. 2007 excel and 100 lines. I need like 100 more added for future months payments.
0
JohnBusiness Consultant (Owner)Commented:
If you cannot do anything with the worksheet, look at Stellar Tools

http://www.stellarinfo.com/excel-recovery.htm
0
Rory ArchibaldCommented:
Can you see "[Shared]" in the title bar of the application after the file name?
0
WO2015Author Commented:
Yes Rory, [Read Only] [Shared]
0
Rory ArchibaldCommented:
You can't change the protection in a shared workbook. You need to unshare it first: click Share workbook, then uncheck the option to allow changes by more than one person. You should then be able to unprotect it.
0
WO2015Author Commented:
I did that and I still cant do anything on the actual Sheet. The unprotected button is now click able. When I click it, it is asking for a password.
0
JohnBusiness Consultant (Owner)Commented:
It looks like you need to repair the file.
0
WO2015Author Commented:
This is a program I have to pay for?  Are there any other solutions from anyone?
0
Rory ArchibaldCommented:
Well, yes, it would. You can try simply pressing OK in case the password is blank. If not, you'll need a password breaking routine - there are loads of them you can find with Google.
If it's not confidential, post the workbook here and I'll remove the password.
0
JohnBusiness Consultant (Owner)Commented:
If you value your data, go for the best software you can find. Stellar is not that expensive. There are free ones, but you want good ones.
0
WO2015Author Commented:
Thank Rory, I will attached the file, that is a huge help. The tab I am speaking of in particular is the Bank Record Tab.
Michigan-Wolves-East--00financial-statem
0
Rory ArchibaldCommented:
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
WO2015Author Commented:
You rock!! Thank you Rory!!!
0
Rory ArchibaldCommented:
You're welcome. :)
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.