I use a mixed environment of Win10 and OS X Yosemite. I have Office 2016 installed on both. I use OneNote to organize some Word and Excel files that are opened, modified, and then saved back to OneNote. It has all worked fine and as expected in the Windows environment for several years, Win7, Win10, various versions of OneNote. It works as expected right now. However, when I open a notebook on the Mac, these files are all read-only and it invites me to 'Duplicate' the file locally with a button.
This defeats the purpose of what I am doing. Does anyone know how to fix this, or is it a quirk (or feature) of the Mac version specifically? Thank you very much. Is the file saved and opened in any other location? The file exists only as an embedded file in OneNote, and is not open anywhere else. It may have been originally created on another computer, but was then placed in a OneNote notebook. From where are you opening the One Note notebook?
Excel 2010 and 2013 also use a 'Protected View' banner that prevents editing unless you click the 'Enable Editing' button on the right side of the banner. Read-Only in Excel. Read-Only to.
The OneNote notebook is being opened from an iMac HD running OS X. The notebook itself is of course on OneDrive. Further to the issue, I did a clean experiment this morning. Within OS X, using Word 2016 for Mac, created a word document, saved it to the desktop, quit Word, opened OneNote, inserted the saved word document, deleted the original word document, double-clicked on the embedded document. It opens correctly, except that it is read-only. A notification bar at the top of Word invites me with a button to create a duplicate for editing.
In other words, OneNote Mac 2016 refuses to open in read/write mode an embedded Word (or Excel) file, irrespective of where it was created, including on the same computer. From a W10 computer, the document opens normally, i.e. Read/write, can be edited, re-saved, etc. It is hard to believe that OneNote Mac was designed this way (i.e. Only as a read-only archive for Word documents) and so I assume I have some soluble misconfiguration. Or if that's just the way OneNote Mac works, just need to know. Thanks for your interest.
Yes they can. From: Select the entire worksheet by clicking the Select All button (the gray rectangle in the upper-left corner of the worksheet where the row 1 and column A headings meet), or by pressing CTRL+A or CTRL+SHIFT+SPACEBAR. Show the format cells dialog box by clicking the Expand button to the bottom right of the Font section of the Home ribbon, and then click Protection tab. Click to clear the Locked check box and click OK.
Select the cells that you want to protect. To select nonadjacent (noncontiguous) cells, hold down CTRL and click the cells that you want to protect. Return to the Format Cells dialog box, and then click the Protection tab. Click to select the Locked check box, and then click OK.
Click the Review tab, and click Protect Sheet. (Type a password, if you want one.) Then click OK.