Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.

learn more… | top users | synonyms

0
votes
0answers
103 views

export specific columns/fields of list to Excell and not the whole list. How?

End users doing export of list to Excel by going to List and choosing Export to Excel. Well this works fine, but the user wants only some columns to be exported not all columns. I've created "another ...
0
votes
1answer
30 views

Roles and analysis of results Excel Surveys

I have a excel survey created in a SharePoint page. Right now if I share the link, anyone can fill in the survey. Can I somehow restricted so that only users with an account on the intranet, or ...
0
votes
0answers
40 views

Save the modified date from sharepoint to sharepoint drive

I got this VBA Excel document where I map a network drive which is the sharepoint drive folder that I have admin rights for. The problem is that when people publish their document then the sharepoint ...
2
votes
2answers
550 views

How to save a list in a csv file via Powershell

I have a SharePoint online list with more than 9000 items and 22 column. The list is being populated on daily basis. I am taking backup manually every morning by saving the list as excel file in the ...
0
votes
1answer
42 views

How to Output Specific Columns to Excel

I have a custom application page that pulls data from one specific list and exports to excel. Below is the code that performs the work: <script runat="server"> protected void ...
0
votes
0answers
29 views

Create list with data from Excel files

I use SP 2013 and have a requirement to capture values from all the Excel files in SharePoint. All the files have different file names, but have the same sheets and need to refer to same cell in each ...
1
vote
1answer
13 views

Different result in OData Assignments

Based on this question: msdn forum (it's my question too) I got different result OData in Excel 2013 and Browser. Excel give more result than Browser. My app use result from Browser, so some data ...
0
votes
0answers
25 views

SharePoint - saving excel library template

I have a requirement here which I would like to know if this is possible. Firstly I have setup a Document library to have a custom template which is in Excel. Basically its a financial template that ...
0
votes
1answer
60 views

How to export all list data from Web Scope to an excel file?

It would be greatly appreciated if someone can point me in the right direction on how to export all list data from a site to an excel file. Below is what the desired output should be. I've looked ...
1
vote
0answers
38 views

Auto reopen/refresh document

Is it possible to automatically reopen office document i.e excel sheet or word document from SharePoint? The documents are read only and I want a solution to refresh the document automatically when ...
0
votes
0answers
220 views

Unexpected error occurred import excel spreadsheet

I am trying to use the Import Spreadsheet app. I do not have multiple versions of Office installed or multiple languages. I have followed this and it did not work: SharePoint 2010 error when importing ...
1
vote
0answers
164 views

Office Web App - Excel - Open in Excel

I have a very strange situation. I have a Excel 97 (.xls) upload in 2 different libraries. One library is in PROD and one library is in TEST. I can preview .xlsx without any problem. The problem is ...
0
votes
1answer
94 views

Excel connection. Issues with data getting into excel-table from SharePoint

I'm working on a project for a client. This client uses a form in SharePoint to enter and save data from certain projects into SharePoint lists. This data is setup to connect to an Excel file, that is ...
0
votes
0answers
11 views

Create a sharepoint page to validate Excel data and then combine into 1 output Excel file

I have a situation where a dozen or so users send me Excel data. I have a series of rules to validate the data. I open each Excel file and apply the validation rules. If the file contains errors, I ...
0
votes
0answers
21 views

Data Entered in Browser View Does Not Show in Excel Document

Data has been entered into an Excel document by selecting "Edit in Browser" and then edit in the Web Apps. This data can be viewed when you select view in browser or edit in browser, but it does ...
1
vote
1answer
186 views

REST API Link to edit excel/word doc online

I am using the O365 REST API to display/organise files and currently xls/doc files have to be downloaded then opened in an editor in order to edit them. Is there a way to open these in the Word/Excel ...
0
votes
0answers
52 views

Does Excel Web Apps support xls format - SharePoint 2013 with OWA

I have a sharepoint 2013 with OWA configured . But it seems .xls files aren't supported. Is this true? If yes is there an alternative option?
0
votes
0answers
53 views

Problems editing Excel only document in a SharePoint library

I have several users with Contributor accesses to a library. One user can open and edit all word and power point documents, but cannot edit an excel document. All the others with same permissions ...
1
vote
1answer
141 views

Schedule a macro in an excel saved in Sharepoint 2013

I have an excel file with a macro that I would like to run twice a day automatically. The file is shared in a Sharepoint 2013 site. Is it possible to schedule this macro? Thanks!!!
0
votes
1answer
247 views

Unable to refresh data from sharepoint list in excel services

I've a SharePoint farm with Excel Application Services configured. I've created a Excel workbook with OData connection to SharePoint list. In Excel web view, I can't refresh data. Need help !
0
votes
0answers
28 views

Sharepoint List to Excel Update Excel Webpart

I have a list that is over the 5000 view threshold. The thought process was to export this to an Excel file, run Pivot Charts and then show the charts on a SharPoint Page using the Excel Webpart. ...
0
votes
0answers
44 views

Synchronize Excel 2013 to SharePoint 2013

I tried several ways to synchronize an Excel 2013 sheet to SharePoint 2013. For example download and see this MS Add-In It works once, but I got a problem report after saving the sheet and trying it ...
1
vote
1answer
64 views

Unable to open Excel documents on SP 2010 website

As of today one specific user is having issues opening Excel documents from a Sharepoint 2010 site. Whenever he tries to open one he gets the following error message. The screenshot is in Dutch but ...
0
votes
0answers
107 views

Excel charts do not refresh on Sharepoint

It seems that the charts in Excel webpart do not refresh on Sharepoint if the series of the chart are connected to some named formulas / UDFs. It seems that anything beyond a simple name connected to ...
0
votes
0answers
104 views

Anonymous Users cannot open XLSX/PPTX files from a SharePoint 2010 document library

Scenario :- Environment :- SharePoint 2010 we have a Site Collection and sub-site which has complete Anonymous Access and all the Document Libraries under the sub-site are given View Items ...
1
vote
0answers
71 views

Editing sharepoint online list in Excel

For some reasons I want to edit my SharePoint online list in Excel 2013 spreadsheet. What are the possibilities?
1
vote
1answer
15 views

Excel Service Not Work after Import an Exported Application

my Excel service is not working.My Excels opening in my Client MSExcel but not open in Browser.its happen after after my application has problem and I have to Export and import again to work ...
1
vote
1answer
592 views

Which Excel functions are not supported by SharePoint calculated columns?

This MSDN article lists various functions that can be used in SharePoint calculated columns, and also includes the following disclaimer: Note Microsoft SharePoint Foundation formulas ...
0
votes
1answer
17 views

importing excel onto sharepoint and use the data to build reports?

Is it possible to do this with sharepoint? I have read quite a few introductory articles that seems to hint on the possibly of acheiving this, but I couldn't find any tutorials on it. Can someone ...
0
votes
0answers
100 views

Office Web Apps + SP2013: Why is only Excel opening in browser by default?

I just installed Office Web Apps and configured it to SharePoint 2013, but only Excel seems to open in the browser by default. Word, PowerPoint, PDF etc. opens in client application. Preview works ...
0
votes
0answers
34 views

“This workbook cannot be opened…” on 64bit IE

So, The message when trying to open an excel file from SharePoint goes like this This happens when I use IE, specifically the 64bit version. If I use the 32bit version, it runs fine. Now, this is ...
1
vote
2answers
650 views

Using Chrome to Open an Excel Workbook

I thought there was a way to manage ActiveX extensions on Google Chrome, specifically one that manages how Chrome handles Excel workbooks when you click on the hyperlinked title in SharePoint. Is ...
0
votes
0answers
36 views

Sharepoint Mutiple Lists, Excel import & export questions

Here are a few questions i have regarding SharePoint & Excel - Using 2010 I have created a list that is an "Order Intake Forum" It asks the user various questions in order to place an order ...
0
votes
1answer
19 views

Who has precedence?

If there's only one user who has "can edit" permission and he has it open on his Desktop, do his changes over write what a "can view only" user is seeing in Excel Online? When would the viewer see the ...
0
votes
2answers
309 views

Cut and Paste not working in Datasheet view Sharepoint 2013 O365

I have a question regarding an unusual error that I can't seem to resolve. I have a document library and am trying to cut and paste metadata from an excel 2013 spreadsheet into columns in a datasheet ...
0
votes
0answers
25 views

Excel filename affects SharePoint ability to open in browser?

SharePoint version 4 (14.0.0.7137) says "an error has occurred" when attempting to 'view in browser' an Excel file located in a library. If that same Excel file is renamed using the Edit Properties ...
1
vote
2answers
87 views

can I import spreadsheets into sharepoint list without excel installed locally?

Is there a way to import a spreadsheet into SharePoint List if you don't have Excel installed locally? Can Office Web Apps or even Google drive sheets be used instead of excel? Edit: I have Excel ...
0
votes
0answers
365 views

We can't do that because the file is no longer checked out or has been deleted

I have an issue with Sharepoint 2010 and Excel 2013 i get the error message: We can't do that because the file is no longer checked out or has been deleted This happens when: I create an new excel ...
1
vote
1answer
301 views

sharepoint - accessing excel files from VBA

I'm trying to access SharePoint directory from Excel VBA and loop over all files at this directory. But when I try to refer to the directory, then I get this error in return: Path not found I ...
0
votes
1answer
257 views

How to create editable table in Sharepoint

I want to use Sharepoint to host a table that multiple people can edit (like an online spreadsheet, for example). I have tried various things which have not worked: I tried downloading a plugin for ...
0
votes
0answers
40 views

What else is in the _layouts folder?

I found a useful way to force an InfoPath form to open directly in the InfoPath client (even across different SharePoint domains) by using the FormServer.aspx page within the _layouts folder. I do ...
0
votes
0answers
20 views

User can't refresh data in Sharepoint List after SQL View Def changed

I am trying to support a user who uses a SharePoint 'report' (ie Excel SS). The report is based on an SQL Server 2008 View. The view definition was altered to source data from different tables within ...
0
votes
1answer
16 views

How to syncronize an Excel document in SharePoint with Access

I have an Excel Sheet stored in a SharePoint list, but this list will be updated every month. So some employees get the Access file and need to fill in their values, but they should just open the ...
0
votes
2answers
180 views

How export list in excel file

I want to create a button that exports specific list into the excel file. But when I do it I always get the same error: Error List does not exist. The page you selected contains a list that does ...
0
votes
0answers
75 views

Export list to excel issues with data type number

so I have a two lists that are connected using lookup, when i export the list to excel the number column (its a lookup column) shows as 10.000000 instead of just 10.. I have tried formatting the cells ...
0
votes
0answers
17 views

Office documents stalled in loading state form expansion list

After opening and closing excel files shown on the right picture they disappear and all I see is Loading shown on the left picture. It stalls there and it will not load anything. The only way for me ...
1
vote
1answer
293 views

Data Connection does not refresh in Excel

I have a SharePoint list; Exported into Excel file and set the property to refresh Data Connection every time the file is opened. It worked very well in Excel installed on my system but when I ...
0
votes
0answers
19 views

Refresh data in online PowerPivot Excel sheet?

I have a Excel sheet that loads the data from a SharePoint list. If I do the following I get below error: Make a pivot table to display data. Save and upload the sheet. Now to Refresh the data to ...
0
votes
1answer
29 views

Excel Files in SharePoint Designer

I added excel file (.xlsx) in SharePoint Designer. These files appear as notepad in SharePoint Designer. I want to these files appear as excel file. How can I do this?