Lock excel file if incomplete

Occasional Visitor
Please can someone assist me, I have created excel file with columns and I’m working with lots of people on the file “shared” is it possible to unable the last user to save the file if there’s missing information or if the use left blank columns because I need everyone to fill in all the details so that we can get full information
1 Reply


If I may recommend knowing the Excel version, the operating system,

the storage medium (hard drive, OneDrive, Sharepoint, etc.),

explain your project / concern / problem step by step on the basis of this data / file

.. this is of great importance Advantage especially for you.

The helpers do not need any time to guess what it might be.

To be honest, this is usually the reason when no one replies to a message.


Here is some additional information on this topic:

Share your Excel workbook with others

About the shared workbook feature

Protection and security in Excel

How to allow certain users to edit cells range in Excel?


Hope I was able to help you with this info.



I know I don't know anything (Socrates)