I'm on a PC. I protected my worksheet, except I left a few cells open to edit via the 'Allow users to edit Ranges' button. When I send this spreadsheet to others. the PC users can edit those few designated cells (good), but the mac users can't (bad). It's like the Mac version of excel is locking the entire sheet without regard to the few cells I said to leave editable.
To make matters worse, if the mac user opens the spreadsheet in Apple Numbers, nothing is locked at all.
One of my mac users is on version Mac Excel 14.6.0. When I help him unlock the sheet, you can see there's no button to specify which cells should be editable. That makes me think the mac version of excel doesn't have this feature.? I'd show you a screenshot but I don't see where I can attach a picture to this thread?
Is this a known issue? What can I do about it?
To make matters worse, if the mac user opens the spreadsheet in Apple Numbers, nothing is locked at all.
One of my mac users is on version Mac Excel 14.6.0. When I help him unlock the sheet, you can see there's no button to specify which cells should be editable. That makes me think the mac version of excel doesn't have this feature.? I'd show you a screenshot but I don't see where I can attach a picture to this thread?
Is this a known issue? What can I do about it?
Allow Users To Edit Ranges In Excel For Mac 2017
I am using Microsoft Excel for Mac version 16.27. I need to allow specific users to edit specific ranges. It know that I need to click on 'Allow users to edit ranges' in the review section, however that button is not showing up for me. My sheet is unprotected, so I can't figure out why it's not showing up. Click on Allow Users to Edit Ranges under changes group. Sticks karl edward wagner pdf. “Allow users to Edit Ranges” dialog box will appear. Click on New. You can write the title as per your need, and in the next tab, select the cell. And then click on Permissions. Where you can add the users whom you want to edit in data. Click on Add. Enter the object name and then. Feb 08, 2016 I'm on a PC. I protected my worksheet, except I left a few cells open to edit via the 'Allow users to edit Ranges' button. When I send this spreadsheet to others. Conexant high definition smartaudio 221 driver windows 10. The PC users can edit those few designated cells (good), but the mac users can't (bad). It's like the Mac version of excel is. Then the users can sort and filter in this protected sheet. Email address extractor 3 0 1. Aplus accounting software free download. If there are multiple sheets needed to protect and allow users to sort and filter, you can apply Protect Worksheet utility of Kutools for Excel to protect multiple sheets at one time.please go to free try Kutools for Excel first, and then go to apply the operation according below steps.