3
votes
2answers
267 views

Retrieving list items from multiple sites via OData with Excel

I want to build a report: with Excel 2013 + PowerPivot Add-In using data from SharePoint Online that should work in Excel Services (so I'm not able to use VB, Power Query, etc.) Report should be ...
2
votes
1answer
40 views

Excel web app Sharepoint Online

I am currently implementing some Powerview in excel that is used on sharepoint online. My problem is that I can't get excel web app to save automatically when something is changed in excel web app ...
1
vote
0answers
18 views

Sharepoint Online 365 and refreshing excel files

Is there a way to have the excel files refresh their links hourly or daily?
0
votes
0answers
38 views

Is it possible to edit excel file on SharePoint online from iOS app?

Currently, I am developing an iPad app which can manipulate excel file that is stored on SharePoint online service. I am able to retrieve data from excel file using Excel Services REST API, but when ...
0
votes
0answers
222 views

Visualization of KPIs in Sharepoint Online

My client wants to show a number of KPI:s on his Sharepoint Online (2013) site. The data source for them will in this first phase be entered manually. What is the best way to display them in a nice ...
0
votes
0answers
206 views

Unable to refresh SPO 2013 Excel Web external oData source

First of .. I see the Excel Web access webpart on SPO 2013, but is Excel Services available on SPO 2013 and if so, where is it and how do you enable it? So, I have this cloud test users. I ...
2
votes
0answers
54 views

SharePoint Onine List as Datasource to Excel Services / Business Intelligence in SPO

Trying to join 2 SharePoint Custom Lists sources into an excel Services Graph. If so, any BI option for formating list data on an SPO page? Possible now under SPO 2013 A3 license? Confused about ...
1
vote
2answers
346 views

Import a single row from Excel spreadsheet

I'm currently trying to copy a single column from an excel sheet and import it in an existing list on sharepoint. I tried this via microsoft access, but i'm only allowed 255 characters per row! Is ...
1
vote
0answers
76 views

Need to be able to select on a column that can have one ore more values

I have a column in a sharepoint list that lists the various departments within my company. One or more of these departments can be selected. Since the column does not show up as a selection when I ...