troubleshooting Question

Using something other than Microsoft Office with Sharepoint Online

Avatar of Tarkisal
Tarkisal asked on
Microsoft Office
5 Comments1 Solution857 ViewsLast Modified:
We use Sharepoint Online for our main company document storage and management. When a user opens an Office file (.xls, xlsx, .doc, and docx most commonly) it usually opens into Word or Excel Online. This is fine but limited. Often, the user will have to then go to Edit and then "Edit with Excel (Or Word) and those programs will open up.

The problem is 85% of my users don't use Microsoft Office for anything but basic editing. I AM looking into seeing if just using the Excel and Word online will be sufficient going forward, but it's frustrating to have to buy new copies of Microsoft Office Home and Business for $190-$220 a PC just so they can use this slightly added functionality.

Here is my question -are there any free or cheaper alternatives that will work with Sharepoint Online? I've tried LibreOffice and WPS Office and, while those programs can easily read all of those file types, Sharepoint Online simply doesn't see them as available. If I was to download the file I'm trying to open I could then edit it in WPS Office and then re-upload it, but I'm wondering if there is a way to force Share Point Online to see these other programs and function as if they were opening with Microsoft Office. (The programs are listed as the default application for each file type listed)

I understand Microsoft probably has gone out of their way to not allow a program other than Office proper to work with Sharepoint Online, but if anyone knows of a way to get Sharepoint Online to recognize a different program that would be very helpful as Office 2007 support is ending soon and I will have a very large expense coming up if I can't find a solution. More information below:

Dell PC with Windows 10 Pro
Have tried WPS Office 2016 and Libre Office
See screenshots below for result
Users have Office 365 Subscription K2 or E1 which gives them sharepoint access but not monthly Office 2016 installations
Program.jpg
Error.jpg
ASKER CERTIFIED SOLUTION
Scott C
Senior Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros