more-arw search

Q&A Forum

How to Protect Excel Worksheet from iPads?

Dale Bolen's Profile

how to protect excel worksheet on ipadsI'd like to protect a worksheet in Excel (version 2010 running in MS Windows). I have found that opening the file on an iPad (running the version of iOS that is current as of May 2013) completely circumvents the protection. The iPad user can edit any cell in the file without entering the protection password, whereas the Windows desktop user must know the password to the file to make any edits.

Has anyone found a solution to this? I've checked MrExcel.com and a few other sites but haven't found a fix. 

Answers

Topic Expert
Brenda Goudey
Title: CFO/VP of Finance
Company: KDR Designer Showrooms
(CFO/VP of Finance, KDR Designer Showrooms) |

I was unaware of the problem, but appreciate knowing there is an issue. Some of our sales staff has just recently started using iPads, so I will keep this in mind and watch for a solution.

Julia Hubbard
Title: Business operations & Finance, Student A..
Company: California State University Monterey Bay
(Business operations & Finance, Student Affairs, California State University Monterey Bay) |

I am afraid it doesn't seem possible if they open it in numbers, I found this post on the subject.
"Perhaps Apple does not see this as such an "important issue" that needs fixing.

Many spreadsheet applications, including MS Excel, do offer the ability to lock individual cells. But those applications produce documents consisting of a single large table, on which every cell in the document must be placed.

Numbers uses a different model: Tables are smaller, generally have a single purpose, and may be located on a number of different Sheets ('canvasses').

Implicit in that model is the ability to separate data entry from calculations by placing the two tasks onto separate sheets. Locking the table(s) containing the calculations may be used to prevent inadvertent editing of the formulas. For that matter, locking the table(s) containing the data could also be used to prevent (inadvertent) editing of the data.

And, no, password protection for that locking is not available. That was also true in iWork's predecessor, AppleWorks. Like the iWork applications, AppleWorks offered password protection at the document level, but not for anything short of that. AppleWorks's spreadsheet module, which used the large, single table model, did offer the ability to lock single cells or groups of cells (but not to assign a password to that lock/unlock operation).

And, as an aside, "Apple's Excel for Mac" is emphatically not among the spreadsheets that "have the ability to lock cells." There's a very simple reason for that: Applications that don't exist can't have that (or any) ability, and "Apple's Excel for Mac" does not exist. Excel for Mac is a Microsoft application that runs on the Mac platform.

Regards,

Barry

PS: If this is as important an issue as you make it to be, you should Provide Numbers Feedback to Apple, requesting a Feature enhancement be added to a future edition of Numbers providing this ability. Use the item of that name in the Application menu (in Numbers, the "Numbers" menu), or click the link in this message."

9108 views
Topics

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.