ms officenumberspassword
Windows
I have an Excel file whose all sheets are protected with password, and even the Excel file itself is password protected. In the Windows version of Excel, I have no issue with this, password protection seems to work as intended.
Mac
When I opened the same Excel file from Windows using Numbers on macOS, only the Excel file password works, individual sheet passwords don't work and I can see the formula in Numbers.
Am I doing something wrong in Excel for Windows to protect the workbook?
This appears to be a limitation of the PDF generator within OSX itself. It appears as though the behavior has been present in OSX versions 10.5 Leopard, 10.6 Snow Leopard, 10.7 Lion and 10.8 Mountain Lion. According to posts within the Microsoft Excel 2011 support pages (here, here and here) when you initiate the print to PDF command from within Excel 2011 the program hands off the actual generation of said PDF to the operating system. On the surface it appears as though OSX is interpreting the page orientations differently and outputting as separate PDF files. I checked through the known issues with Microsoft Excel 2011 to see if there is an outstanding bug for this behavior but nothing seems readily apparent. The support pages contain references to different methodologies to get around the problem such as:
The information available reports varying degrees of success depending on what solution you ultimately end up choosing. All the solutions seem to be more of the same shim type work arounds with no easy / native (within Excel 2011) solution.
Found it! It's a setting under Preferences > Edit:
Extend data range formats and formulas
Misread it as "date ranges" on the first trawl through preferences. Turning it off stops this happening.
The comment about formulas seems to only mean that it doesn't fill empty cells with formulas when it thinks it's seen a pattern. After turning it off, it still does other automatic format adjustment e.g. incrementing formulas copied across a range:
Best Answer
Numbers is not Excel.
Numbers can only do a subset of things Excel can do with Excel spreadsheets.
If you have done not basic things in Excel (eg protection) you need Excel to undo those things.
This would be true if the original was Numbers and you used Excel on Numbers file.
Each application is different and an export of their specialized file format loses some functionality.
But then again there are things that only Excel can do e.g. Pivot tables.