Prevent Google Drive to exclude cell protection parameters from Excel file

Question

I'm having some trouble in keeping protected ranges from Excel files in Google Drive. In this link there is an original Excel file with a protected cell in OneDrive and in this other link is this very same file but in Google Drive. You can see that when I put the files in Google Drive it just kills the original protection from Excel. Is there a way to prevent it?

Answer 1

I am afraid that both features are completely different and not compatible yet. Microsoft's cell protection feature works only when using Office. If you upload and open the document in Google Drive, Google does not have a way to read the protection included by Microsoft as Google implemented their own cell protection feature as well.

For example, Google's protection feature works similar to the sharing permissions, based in users and email addresses, while Microsoft's protection gets implemented within the document itself.

Google added a compatibility mode for office documents not long ago, so it may be possible that this is available in the future, however at the moment there is no way to merge both protection features.

References:

• Work with Microsoft Office files
• Edit Office files