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.
Learn Excel the FAST way, find out how here 👉 www.excel-university.com/yt
Check out 7 Excel Time Hacks Everyone Should Know here • 7 Excel Time Hacks Eve...
Subscribe here 👉 / exceluniver. . and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!
Watch VLOOKUP Hacks Playlist here ruclips.net/user/playlist?list...
Watch VLOOKUP vs SUMIFS Playlist here ruclips.net/user/playlist?list...
Watch Dynamic Arrays playlist here ruclips.net/user/playlist?list...
Watch Treasure Maps playlist here ruclips.net/user/playlist?list...
Watch Slow to Fast playlist here ruclips.net/user/playlist?list...

[@misterwill3625]

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

[@ExcelU]

You're welcome!

[@raphaelusek]

Thanks sir ❤❤❤

[@slasheddepot]

this really helped me to protect my warehouse formulas

[@wayneedmondson1065]

Great tips Jeff! Thanks!!

[@ExcelU]

Thanks Wayne :)

[@daangauthier5356]

As always, great info!

[@ExcelU]

Thanks :)

[@MrArvirivera]

Thanks, Heisenberg! 😁

[@ExcelU]

Thanks, Jesse.

[@russtaylor4242]

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

[@ExcelU]

Thank you for your kind note, and welcome aboard!

[@lancethomas7816]

Awesome explanation👍🏾

[@ExcelU]

Thank you :)

[@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 RUclips 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.

[@angelica9566]

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?

[@ExcelU]

PivotTable > Options > Layout & Format > Uncheck the 'Autofit column widths on update' checkbox

[@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