Connecting Office for iPad to SharePoint

April 7, 2014 2 Comments by Wedge Black

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. Sign in to Office for iPad (Office 365)

Step 1

Open the Word App. Within the ‘Open’ menu item, touch ‘Add a Place’. Open and Add a Place in Office for iPad

Step 2

Select ‘SharePoint Site URL’. SharePoiont SIte URL in Office for iPad

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. Office 365 Safari SharePoint / O365 URL in Safari

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). Edit the URL in Safari

Step 5

Now copy this nicer, shorter URL. Copy the URL from Safari

Step 6

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

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. If necessary, edit out the %20

Step 7

Now enter your SharePoint log-in details (for your intranet or your 0ffice 365 Site). SharePoint / 0365 user email and password 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. Profile name Sign out

Step 8

Assuming the above tip isn’t necessary, you’re now all done -  enjoy! SharePoint folders in Word for iPad


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. Read only access to documents in Office for iPad


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


Learn more about Excel, PowerPoint, and Word for iPad in ‘How to get started with Office for iPad‘ by Anthony Myers.

If you’re an Office 365 administrator, check out our post on the headache that enterprises face as people individually opt to pay for a personal Office 365 account to get into Office for iPad.

|


2 comments

  • Thom says:

    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?

    Thanks

    - Thom

    • Sam Marshall says:

      Hi Thom

      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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Read previous post:
Sam Marshall talking about digital workplace strategy
Designing a digital workplace around employee’s needs ahead of technology

A technology-driven strategy does not reliably lead to changes in people's behavior. Watch the two-minute video as Sam summarises the...

Close