How to Protect and Hide Excel Formulas From Being Changed in Shared Worksheets

It's happened to all of us. You share your work with a colleague and the next thing you know they've changed your carefully crafted formulas. In this video, I show you how to keep from accidentally changing your excel formulas when you share worksheets with co workers.

[misterwill]

Thank you for explaining the default settings and how to enable restrictions such as Hidden.

[russtaylor]

This was the best explanation after 10 videos, subscribed, would be good to know more about Excel, for instance I hadn't heard of the PMT function before! Cheers

[slasheddepot]

this really helped me to protect my warehouse formulas

[Coloringbuch]

can you do a video on how you can put formulas in but the cell looks empty

[NanasNumbers]

Thanks for all you do. I have a question. I know there is a way to make an Excel so that if someone sends it to another person, it will stop working. I have Excels that I sell & customers have to enter in current data. I understand how to unlock certain cells [so customers can enter current info] & lock others [so customers cannot edit or copy formulas], then protect the sheet. I also add copyright info in locked cells so that no one can resell it. But there is nothing stopping them from looking up a YouTube video on how to remove that protectection. It's actually pretty easy. But I know others in my same niche who create Excels & somehow they protect that Excel from being emailed to anyone else. This is exactly what I need so that no one steals my work & resells it. It's been a huge problem. I come out with a new Excel product and after a month of sales, everyone has it. The customers in my community are very close & share information, so after one person buys it, they just send it to all of their friends. I know there is a way to do this, but all the people selling Excels in this niche are very close mouthed and DON'T share knowledge.

[angelica]

Why can not open ithe table with Ctrl 1??

[hanrealistic]

When I refresh my pivot tables, it is annoyingly resizes my column widths. I have read some solutions saying un check LOCK option from the format menu. So I did it. It is now most of the cells are showing errors, and when I refresh my Pivot table, it STILL changes the Column Widths.. How can I solve this?

[agorgedslug]

Can I HIDE my changes in a shared workbook, when I am not the creator/administrator? My Boss has been treating me like an imbecile when I ask for formulas to be used and tells me 'it can't be done'. I want to make things easier for me and my colleagues, but not give him the luxury of finding out our easy formulas when he doesn't deserve it.

[EDDIEGARAGE]

Very very confusing lock unlock lock unlock