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
”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
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.