Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

Excel to SharePoint 2013 O365 Web App

Have access web app.  Connects to excel well enough, when on my machine using correct SQl 11 native driver, etc.

Now want users to be able to open the spreadsheet from SharePoint and have it refresh just as it does on my machine.  Can do if "visit" each users computer, install the driver and make connection, etc.  Essentially just want the spreadsheet to connect to the server side query and present the data.

Isn't there a simpler way that will connect excel (read only of course) to what is essentially SQL on O365?
0
VirtualKansas
Asked:
VirtualKansas
  • 2
  • 2
1 Solution
 
colly92002Commented:
There are lots of options, but they have licensiing implications.

Here are your options:
http://officeimg.vo.msecnd.net/en-us/files/500/002/AF104215773.pdf
0
 
VirtualKansasAuthor Commented:
Thank you, I haven't invested a lot of time exploring these other options.

For now I exported the connection file from my workbook and tested successfully on a second machine. Cumbersome but seemed to work.

Question remains "isn't the a simpler way" to reliably connect the spreadsheet?
0
 
colly92002Commented:
You can use the OLEDB driver for Excel (http://www.microsoft.com/en-us/download/details.aspx?id=13255)
But I can't see how that is any easier than what you are doing.  Here is a nice walkthrough so you can compare:
http://www.layer2solutions.com/en/community/FAQs/cloud-connector/Pages/Office-365-Integration-Excel-files-to-cloud.aspx

Because you are using Office 365 your options are limited without using the Excel integration add-ons, which is why I have pointed  you to teh infographic above :)  If you have access to the BI stuff then you can host your Excel natively in O365 and have done with it.  All the power of Excel with your data stored securely in SharePoint :)
0
 
VirtualKansasAuthor Commented:
Okay I will close this thread with my thanks.

Then I will open a new thread for BI.  Jump on it...

TY
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now