Connecting Office for iPad to SharePoint

Connecting Office for iPad to SharePoint

This is a step-by-step guide on how to connect Word, Excel or PowerPoint for iPad to SharePoint in Office 365 Enterprise. It will work for document libraries in other SharePoint sites too, such as company SharePoint intranets behind a firewall, so long as you also have an Office 365 account. We’ll be talking about ‘Office for iPad’ but note that there isn’t actually an app with this name in the iTunes App Store, you have to download each one individually. There is an app called ‘Office for iPhone‘, and the same process will work for that too. If you’ve experienced a problem signing-in or connecting to SharePoint, this guide can help. It appears Microsoft do not include Office for iPad within their ‘Office 365 Small Business’ offering – you need at least the ‘Office 365 Small Business Premium’ package – see all the prices and choices. You can store documents in four locations when using Office for iPad:

your personal OneDrive (previously called ‘SkyDrive’);

OneDrive for Business;

your iPad;

one or more SharePoint sites, including office 365 where they are simply called ‘Sites’.

N.B. To connect to an on-premise SharePoint intranet, your iPad will need to be on your company network (directly or via VPN).

How to set up Office for iPad to connect to SharePoint Sites

As simple as the set up process is, I found a couple of points regarding the SharePoint URL initially tripped me up. Pay particular attention to the red points, below. Screenshots show Microsoft Word for iPad, but each app is similar. If this is the first time you’ve used the App, you’ll only be able to read documents and not edit them until you sign in to Office 365 (a paid-for subscription). You can connect to your SharePoint Site without an Office 365 license, but you get read-only document views (see the last two screenshots). If this is the first time you’ve used the app, you’ll be asked for an email address to sign in (see screenshot). Use your Office 365 email address if you can. If you’ve already logged in with a different address such as a Hotmail, Outlook.com or One Drive account, then you will be asked for your extra login details in Step 7 for the SharePoint site you want to add.

Step 1

Open the Word App. Within the ‘Open’ menu item, touch ‘Add a Place’.

Step 2

Select ‘SharePoint Site URL’.

Step 3

Now the dialogue box asks for the actual URL (web address) of the place you want to access within SharePoint / O365. I suggest you visit the exact folder within your browser (Safari, usually), by surfing to it just as you normally do when browsing your SharePoint. N.B. If attempting to access an on-premises SharePoint intranet, remember your iPad will need to be on the network either directly by wifi on-site, or via VPN elsewhere. Do not copy the URL from your browser just yet; read on for crucial details.

Step 4

Notice how the URL is pretty long and ugly (above). Delete the bits after the folder that you’re actually interest in (below).

Step 5

Now copy this nicer, shorter URL.

Step 6

Return to the Office app (Word, in this case) and paste the web address into the URL field.

Step 6a

See those %20 bits, in-between the real words? You might have underscores or something else (which is fine), but if your SharePoint locations / folders use spaces, then you’ll see ‘%20’ which may be a problem. It might be necessary to carefully delete the %20 bits, as shown below. Maybe you won’t have to do this but it may help if your attempt to connect fails, so I’m passing on this tip to anyone who’s been stumped.

Step 7

Now enter your SharePoint log-in details (for your intranet or your 0ffice 365 Site). Tip: if you don’t see the log-in dialogue box, or you get an error message saying ‘You do not have permission to access this resource’ then try touching your profile (the photo / name, top left), and then on your name (shown below) and log out of everything. Then open a different Office app (or your OneDrive app) to synchronize your log-ins. Finally, go back to Step 1 and enter the URL for your SharePoint site before any OneDrive access. This should then prompt you to log in. The app will remember if you’ve already activated the license.

Step 8

Assuming the above tip isn’t necessary, you’re now all done – enjoy!

Accessing SharePoint Sites in read-only mode

If you haven’t activated your Apps via O365, you’ll see a ‘Read-only’ message like the screenshot below.

It is possible to connect to SharePoint / O365 Sites without signing in to Office 365 on your iPad – for read-only access to documents.

Tags:

Wedge Black

As an associate at ClearBox, I support Sam Marshall in everything we do online, and I assist clients that are considering redeveloping or replacing their intranet platform. I worked in global and regional organisations as the intranet manager as part of the comms team, before becoming an intranet consultant. I'm the founder of the Intranet Now annual conference. I’ve tweeted about intranets and comms for ten years now.

8 Comments

Great article – but can you tell me, if you work on documents on SharePoint using your iPad Word app, can you completely avoid OneDrive? Or does the app back up your document to OneDrive without your permission or active consent?

Glad you like the article. If the document is already on SharePoint, then it will stay on SharePoint. However, any new documents created within the app seem to default to OneDrive when you try to save them. It does at least show clearly that it’s about to do this. Hope that helps.

Sam

DS

Great article. We’ve got the Office 365 Business Premium and a company intranet, but when I open documents from the company intranet libraries, they open in a browser and are not editable. Should this work? Much appreciate any direction and thank you.

Hi there. I suspect the issue is that Safari on your iPad isn’t smart enough to know that you’re opening a document within Office 365. Try going to the library on your intranet and then copying the URL into any of the iPad Office apps using the step 3 onwards illustrated above. You should then be able to open the file starting from within the iPad app rather than the browser.
Let us know how you get on!

Ratko

Good article, but ADFS part is missing.
If you integrate Your Sharepoint with ADFS and publish it with Web Application Proxy (Windows 2012 R2 component), you can only login with username and password, because client certificate authentication fails, because Word for iPad does not show you certificate selection dialog like in Safari.
Any idea if Microsoft will fix this in the future?