Repair a disk using Disk Utility on Mac - Apple Support. Personally, Excel performance was greatly enhanced after I ran Disk Utility and repaired all my Mac’s volumes. A corrupt user account can cause Excel to be slow. Then type a password for the sheet, and verify it by typing it again. Another user reported the problem goes away in a new Mac OS user account. If there are other cells that still need to be locked, on the Review tab, click Protect Sheet or Protect Workbook. Then click to clear the Locked check box so that it is not selected. Select the cells that you want to unlock. On the Review tab, click Unprotect Sheet or Unprotect Workbook. If any cells should be unlocked, select them. Note: By default, all cells have the Locked formatting unless you previously turned it off. Click the Protection tab, and then make sure that the Locked check box is selected. You may need to temporarily turn off protection so that you can unlock cells. On the Format menu, click Cells, or press + 1. If so, under Allow users of this sheet to, choose the elements that you want people to be able to select or change. If you want people to be able to select and fill out unlocked cells, click to select Select unlocked cells.īefore you click OK to finish, you might want people to do other things to the locked cells, like select them or format them. If you don't want people to select locked cells, click to clear the Select locked cells check box. If you lose the password, you can't access the protected parts on the sheet.

This will force the system to run a drive check and clear some system caches.

First try rebooting into Safe Mode by holding the Shift key down on your Mac when starting up. If you do enter a password, make sure that you choose a password that is easy to remember, or write it down and keep it in a safe place. In light of this, to fix odd slowdowns, you can try removing some caches that may be relevant. If you do not supply a password, any user can unprotect the sheet and change what was protected.

Excel mac os x calculating cells slow