+ Reply to Thread
Results 1 to 28 of 28

Excel on iPad

  1. #1
    Registered User
    Join Date
    03-23-2013
    Location
    NSW
    MS-Off Ver
    Excel 2013
    Posts
    51

    Question Excel on iPad

    I have a worksheet that I have made up on my Desktop using Excel 2013, I have now made it Protected on my Desktop. I have saved the protected file onto 'One Drive' which is required for the iPad to load it from. Now when I attempt to open the protected copy on my iPad all it will do is load the file to the stage it was prior to making it a protected copy. How Can I get around this please ?

    Regards

    Peter

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,330

    Re: Excel on iPad

    ..can you load it from one drive if it isn't protected?
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    03-23-2013
    Location
    NSW
    MS-Off Ver
    Excel 2013
    Posts
    51

    Re: Excel on iPad

    Quote Originally Posted by Richard Buttrey View Post
    ..can you load it from one drive if it isn't protected?
    Hi Richard
    Yes the file can be loaded when its unprotected, but only if it's unprotected when loaded into One Drive before loading to iPad. if I load it to One Drive protected and then unprotect in One Drive when loaded to iPad it says 'can not save saved by different user' or something similar can't remember exact message.

    Regards

    Peter

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,258

    Re: Excel on iPad

    I have Excel 2013 on this laptop and my iPad - I'll see if I can replicate your problem here, Peter.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,258

    Re: Excel on iPad

    OK, well I've tried a simple two-sheet workbook, and adding extra stuff at each stage:

    1. With the workbook protected, it loads fine in Excel for iPad (as read only, of course).
    2. With one sheet of the workbook protected, it loads fine in Excel for iPad.
    3. With one sheet and the workbook both protected, it loads fine in Excel for iPad.

    What exactly is your protection? Worksheet or workbook level, or both? Is this a shared file?

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,258

    Re: Excel on iPad

    Addendum:

    Even using protect and share, I can't replicate your issue. What isn't possible on the iPad, though, is to work directly on the protected sheet: all you can do is save a duplicate and work on that, but the protected sheet(s) will not be editable, as password protection is not supported on iPad. All content remains visible, though.

    How exactly are you 'unprotecting it in OneDrive'?
    Last edited by AliGW; 04-16-2014 at 04:07 AM.

  7. #7
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: Excel on iPad

    How are you opening it on the Ipad, using the webview or the office app?

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,258

    Re: Excel on iPad

    Quote Originally Posted by Kyle123 View Post
    How are you opening it on the Ipad, using the webview or the office app?
    Are you asking me or the OP or both? I'm using Excel for iPad, as I stated in my post (i.e. the MS Office 365 (2013) app). It's part of my Office 365 subscription. I assumed that Peter was doing the same, but you're right: maybe he's trying to access it differently.

  9. #9
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: Excel on iPad

    I was asking the OP as it's something that I would envisage would make a difference. I've never used it, so I can't really help here, but my understanding is that you can't Edit Excel documents on the Ipad without a 360 subscription - seemed like something that had been skipped over that would be worth establishing

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,258

    Re: Excel on iPad

    There were 365 days in the year last time I looked ...

    Yes, you are right: Excel for iPad is free to use as a reader, but to edit files, you need an Office 365 subscription. It will be interesting to read Peter's response, but as he's in Oz, and as it's about 6:38pm in Sydney, he's probably having his supper at the moment!!!

  11. #11
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,176

    Re: Excel on iPad

    Yeah, but it went down for 5 days a few years back

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,258

    Re: Excel on iPad

    Quote Originally Posted by kyle123 View Post
    yeah, but it went down for 5 days a few years back
    lol!!! :-d

  13. #13
    Registered User
    Join Date
    03-23-2013
    Location
    NSW
    MS-Off Ver
    Excel 2013
    Posts
    51

    Re: Excel on iPad

    Quote Originally Posted by AliGW View Post
    OK, well I've tried a simple two-sheet workbook, and adding extra stuff at each stage:

    1. With the workbook protected, it loads fine in Excel for iPad (as read only, of course).
    2. With one sheet of the workbook protected, it loads fine in Excel for iPad.
    3. With one sheet and the workbook both protected, it loads fine in Excel for iPad.

    What exactly is your protection? Worksheet or workbook level, or both? Is this a shared file?
    I am protecting it with 'Protect Worksheet' not Protect Workbook.

  14. #14
    Registered User
    Join Date
    03-23-2013
    Location
    NSW
    MS-Off Ver
    Excel 2013
    Posts
    51

    Re: Excel on iPad

    Quote Originally Posted by AliGW View Post
    Addendum:

    Even using protect and share, I can't replicate your issue. What isn't possible on the iPad, though, is to work directly on the protected sheet: all you can do is save a duplicate and work on that, but the protected sheet(s) will not be editable, as password protection is not supported on iPad. All content remains visible, though.

    How exactly are you 'unprotecting it in OneDrive'?
    With the File loaded protected into One Drive I open it from within One Drive click on Unprotect Worksheet and then save to One Drive, then open it in iPad

  15. #15
    Registered User
    Join Date
    03-23-2013
    Location
    NSW
    MS-Off Ver
    Excel 2013
    Posts
    51

    Re: Excel on iPad

    Quote Originally Posted by Kyle123 View Post
    How are you opening it on the Ipad, using the webview or the office app?
    I open the file via the Excel APP

  16. #16
    Registered User
    Join Date
    03-23-2013
    Location
    NSW
    MS-Off Ver
    Excel 2013
    Posts
    51

    Re: Excel on iPad

    Quote Originally Posted by AliGW View Post
    Are you asking me or the OP or both? I'm using Excel for iPad, as I stated in my post (i.e. the MS Office 365 (2013) app). It's part of my Office 365 subscription. I assumed that Peter was doing the same, but you're right: maybe he's trying to access it differently.
    Yes I do have the Office 365 subscription paid.

  17. #17
    Registered User
    Join Date
    03-23-2013
    Location
    NSW
    MS-Off Ver
    Excel 2013
    Posts
    51

    Re: Excel on iPad

    Quote Originally Posted by AliGW View Post
    Addendum:

    Even using protect and share, I can't replicate your issue. What isn't possible on the iPad, though, is to work directly on the protected sheet: all you can do is save a duplicate and work on that, but the protected sheet(s) will not be editable, as password protection is not supported on iPad. All content remains visible, though.

    How exactly are you 'unprotecting it in OneDrive'?
    I was assuming that I would be able to use it exactly the same on my iPad as I do on my desktop.

    This is what is confusing me as it is coming with can't save, make duplicate, etc it's just confusing jargon and I don't know which way to go with it.

  18. #18
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,258

    Re: Excel on iPad

    If you are using the app in the iPad as opposed to the apps available via OneDrive online, then no, the functionality is limited in the iPad app. I don't know about using the online app, as I didn't try that. The iPad app is useful for viewing files and making minor adjustments, but I wouldn't use it for proper work on a spreadsheet: I'd use my laptop for that.

  19. #19
    Registered User
    Join Date
    03-23-2013
    Location
    NSW
    MS-Off Ver
    Excel 2013
    Posts
    51

    Re: Excel on iPad

    Quote Originally Posted by AliGW View Post
    If you are using the app in the iPad as opposed to the apps available via OneDrive online, then no, the functionality is limited in the iPad app. I don't know about using the online app, as I didn't try that. The iPad app is useful for viewing files and making minor adjustments, but I wouldn't use it for proper work on a spreadsheet: I'd use my laptop for that.
    yes I am using the app in the iPad, I don't know where / how to access the APP via OneDrive, can you explain how l can do this please. I only have a desktop and now my iPad and I have the need to add / change information in my spread sheet whilst I am on the move driving to different locations.

  20. #20
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,258

    Re: Excel on iPad

    What happens when you try to launch the Excel file directly from the OneDrive browser window?

  21. #21
    Registered User
    Join Date
    03-23-2013
    Location
    NSW
    MS-Off Ver
    Excel 2013
    Posts
    51

    Re: Excel on iPad

    Quote Originally Posted by AliGW View Post
    What happens when you try to launch the Excel file directly from the OneDrive browser window?
    If you mean thru the iPad I haven't tried that, didn't realize that I could. I have only had iPad for a couple of weeks still learning how to use it. I assume you thru safari. Give me ten minutes and I will try.

  22. #22
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,258

    Re: Excel on iPad

    That's what I'd try, yes. If that launches the iPad app, then the iPad app it will have to be.

  23. #23
    Registered User
    Join Date
    03-23-2013
    Location
    NSW
    MS-Off Ver
    Excel 2013
    Posts
    51

    Re: Excel on iPad

    Quote Originally Posted by mills49 View Post
    If you mean thru the iPad I haven't tried that, didn't realize that I could. I have only had iPad for a couple of weeks still learning how to use it. I assume you thru safari. Give me ten minutes and I will try.
    I'm not sure what I've got here now, it appears to opened my file with a slightly different layout, not my spread sheet layout, but the ribbons are different and a lot more of them and I can view the spreadsheet but have no navigation movement around the spreadsheet or keyboard functions to change anything.

  24. #24
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,258

    Re: Excel on iPad

    OK - so it seems you've opened it in the online app. I would have thought you'd be able to navigate.

  25. #25
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,258

    Re: Excel on iPad

    I've just opened a file within the browser on my laptop, and although it's navigable, there is no access to protection features. It is limited in a similar way to the iPad app.

  26. #26
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,258

    Re: Excel on iPad

    I have opened the same file in the online app via Safari on my iPad, and it is navigable by touch (no scrollbars necessary) and I can edit it. If your worksheet is protected, then you won't be able to edit anything on that sheet and there is no way that I can see to unprotect the sheet via this app. Hope this answers your question.

  27. #27
    Registered User
    Join Date
    03-23-2013
    Location
    NSW
    MS-Off Ver
    Excel 2013
    Posts
    51

    Re: Excel on iPad

    Quote Originally Posted by AliGW View Post
    I've just opened a file within the browser on my laptop, and although it's navigable, there is no access to protection features. It is limited in a similar way to the iPad app.
    I can navigate by touching the screen but have no keyboard functions

  28. #28
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,258

    Re: Excel on iPad

    I think this is because the worksheet is protected. I get the keyboard as soon as I click (touch) into the formula bar, which is where your text or number entry would occur. Is this not happening? If not, then the worksheet must be locked.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel Audio to iPad
    By ISUCyclones in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2012, 12:24 PM
  2. Excel on an iPad
    By Andythefish in forum Excel General
    Replies: 4
    Last Post: 04-25-2012, 10:33 AM
  3. Excel Solution for iPad
    By tindercd in forum The Water Cooler
    Replies: 23
    Last Post: 04-07-2012, 04:17 PM
  4. Excel 2010 and iPad 2
    By Botts750 in forum Excel General
    Replies: 2
    Last Post: 10-04-2011, 02:21 AM
  5. Excel and iPad
    By Botts750 in forum Excel General
    Replies: 2
    Last Post: 10-01-2011, 06:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1