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

learn more… | top users | synonyms

0
votes
0answers
22 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
3answers
38 views

How to export list items in same order in a list to excel 2010 (console application)?

I require to export list items from a SharePoint list to Excel. The order of items in the Excel sheet should be the same as in the list. Can somebody suggest console application code for this?
2
votes
0answers
34 views

Cannot Open Excel sheet in web-browser

I am having a problem opening the excel sheet in web browser, it throws an exception.. Excel Web Access >> An error has occurred. Please contact your system administrator if this problem ...
0
votes
0answers
43 views

Can't connect to sharepoint for data refresh since upgraded to Excel 2010

I use Microsoft Enterprise Project Management (EPM), which is based on SharePoint Services and started having problems after upgrading my local machine Office from 2007 to 2010. I can normally ...
1
vote
1answer
161 views

Compare Date to constant using ACE.OLEDB.12 in Excel VBA [closed]

After a lot of searching, trial and error, I finally managed to come up with an Excel VBA procedure that will return date from a SharePoint list. The query works fine if I do not qualify the Select ...
3
votes
1answer
108 views

Cannot Edit Excel Document with Full Control Permission

There is a document with permission. User A and User B can only edit the document after they open from sharepoint. User A has Excel 2013 in his PC. When he opens it in Excel it says "The document is ...
0
votes
0answers
181 views

Excel 2010 VBA to open most recent Major Version of Excel 2010 file held in Sharepoint 2010

I am using Sharepoint to enforce version control for a number of Excel Spreadheets. I want to use the major & minor versions feature to allow me and the development team to make changes against ...
0
votes
1answer
61 views

How to show version number when using 'Export to Excel' command

my firm is transferring a project to another firm. The new firm wants a list of all of our files. I went into our sharepoint library and selected "Export to Excel" which returned a spreadsheet with ...
0
votes
0answers
19 views

Excel files in a share folder cannot be open by another folder managers

I have a simple share folder in SharePoint with my co-workers that I have created. The folder contains sub folders and, ultimately, Excel files. In my computer I can see and open the Excel files ...
0
votes
1answer
116 views

Synchronize excel file with SharePoint online list

I want to synchronize data from excel file with SharePoint list on office 365. I have already built a utility which uses client object model to achieve this but it is very slow as item count are in ...
0
votes
1answer
44 views

Get Chart web part to dynamically change with original share point list

I have a sharepoint list that contains a list of projects and their technology. Example. P1 - Java P2 - SAP P3 - Oracle P4 - Java p5 - Oracle I want to be able to represent the Tech distribution ...
1
vote
1answer
189 views

Thumbnails/snapshots don't show in PowerPivot Gallery when the document refreshes on open

I have several excel documents containing PowerPivot tables. They all connect to a SSAS Tabular service (on SQL 2012) via a .odc connection file, all of which is hosted on SharePoint 2013, using the ...
1
vote
2answers
43 views

Merging excel documents similar to slide libraries

I have a scenario that would be perfect for slide libraries - but they're excel sheets. We use SharePoint 2010. Also, I do not have access to the server itself... Just site collection administrator. ...
2
votes
1answer
118 views

Cannot retrieve all items from large SharePoint list via Excel data connection

I have a large SharePoint 2010 list (~60,000 items) in which the list view threshold has been turned off. Recently, we've encountered the problem that exporting the list to Excel only yields a subset ...
0
votes
0answers
36 views

How to synchronize an excel spreadsheet with SharePoint 2010?

I have a spreadsheet being fed by several SQL Queries. After the queries are run, the fields repopulate and I have Graphs/Charts and formulas that visually display the data. I'm trying to simply ...
0
votes
0answers
65 views

Error when copying an empty choice field from Excel into a SharePoint 2013 Datasheet View

Once in a while, we need to upload a whole list of Project Ideas into our SharePoint 2013 Enterprise system. There is a datasheet view to copy all the fields from Excel into the list. Some of the ...
1
vote
1answer
3k views

Why are .xlsm files opened as read-only when .xlsx are not?

I have a number of Excel files attached to SharePoint 2010 records. Those with .xlsx extensions open quite happily and can be edited and saved back, but those with .xlsm (i.e. with embedded macros) ...
0
votes
3answers
6k views

Cannot open word document and Excel from Sharepoint 2010

I am not able to open any word documents and Excel from my Sharepoint2010 sites. I was able to open them before I re-installed everything from scratch. When I try and open any uploaded Excel document ...
1
vote
1answer
102 views

Generating Excel Export using a link?

Trying to build a 'generate report' link with various options. I would have three links, each with different list filtration criteria. The idea is then that whilst people are on that page, they can ...
0
votes
2answers
107 views

Unable to save excel to SharePoint 2007

I have a user who is having issue saving changes he made to an excel file stored in a document library. He has contribute access to the library. The setting on the library does not require check out ...
0
votes
2answers
2k views

Open docs from SP2010 in excel/word crashes

I have: SP2010 rented from a company. 1 site collection I have IE 9.0.8 For about a 6 months I have this consistent problem. When I click on a Word doc or Excel doc, I get a choice to edit, I do ...
0
votes
1answer
76 views

Issues in some contents of Excel web access web part in mozila firefox and google chrom

Whenever we create an Excel web page, using Excel web access web part, we got an option "open in excel". That "open in excel" option is not working in google chrome but it is working in Internet ...
0
votes
0answers
42 views

Need Help | Sharepoint 2007 Excel Export Issue

I am trying to export the data from SharePoint 2007 Form library into excel by form library out of box Export to Spreadsheet option. The view getting imported having folders for each Year-Month, And ...
1
vote
2answers
56 views

Sharing a Spread Sheet on SharePoint and making sure Data changes reflect in document

I have a spread sheet to which i make changes weekly. There are different kinds of data in the spread sheet. I want to make different parts of data visible to different people in my team on the ...
1
vote
0answers
18 views

Make First Sheet Display in Excel of Sharepoint in Browser

I have a Excel Web part and make an excel appear in browser throught this web part. There is 4 sheets in excel but when I open the page , firstly the third sheet appears but not he first sheet. How ...
1
vote
1answer
101 views

Help using Excel REST

Posted a question yesterday and got a great suggestion to use Excel REST. I've looked at the documentation but had a basic question about how to apply it. I've got 3 workbooks in a document library ...
0
votes
1answer
168 views

Dashboard from Excel file with Data Validation and Protected Sheets

I want to create a dashboard in Sharepoint using data from Excel Workbooks. Each Workbook has 2 sheets: Data and Dashboard. The Data worksheet contains raw data and the Dashboard tab contains KPI's ...
2
votes
3answers
15k views

Disable Excel Web Access?

Is there a way to disable Excel Web Access (_layouts/xlviewer.aspx) completely on a Site Collection? (SP2010 Enterprise) I have enabled the "Open in Client Applications" feature and it works fine in ...
0
votes
1answer
24 views

In Excel, OnClick I need to save then add a workbook to a SPT 2010 Standard Edition doc Library? How to do this?

I am not a coder, but I have seen VB scripts that "kind of" does this.. I'm willing to try (nervous smile). I need to add a button in an Excel workbook that will "auto upload" the workbook to a ...
1
vote
0answers
80 views

How to apply “Table Style Medium 4” template formatting to excel created using open xml?

Hi I have a few datatables (No DataSet). I have created a method which will write datatable to excel. after writing data from datatable to excel, I will again call the same method of excel generation ...
1
vote
0answers
320 views

Check in error “We can't do that becuase the file is no longer checked out or has been deleted”

First question ever from this rookie, please be kind. Sharepoint 2013, Office 2013 Std 32 bit. Win7 Pro 64bit Sp1. I've got an issue with checking my .XLSX file back in after any edits. Error message ...
0
votes
1answer
516 views

How Can I Paste Multiple Values in a SharePoint Checkboxes (Multiple Selections) Column in Datasheet View?

I am trying to copy a column of data from an Excel spreadsheet, exported from a proprietary Lotus Notes database application (groan), to a SharePoint list presented in Datasheet view. The Notes app ...
1
vote
1answer
72 views

IE crash - when copying data from Excel to Sharepoint List

I have an EXISTING SP List, and am trying to copy / paste data from an xls file into the list. I have a view created that mirrors the columns I am trying to copy in. It appears to copy / paste okay, ...
0
votes
1answer
50 views

Excel signature lost when opened from sharepoint 2010

I hope you can help me to understand this issue. I have a digitally signed Excel document. It is marked as final, it contains one signature. I uploaded that document to sharepoint 2010 document ...
1
vote
1answer
137 views

Custom Field and export to Excel

I have a custom field that inherits the Number field (I change the UI of the field, but not the storage). When I export to Excel a list that contains an instance of this field, I get different ...
0
votes
0answers
165 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
23 views

SharePoint 2010 & Excel & Refresh from access databse

I have an excel document that's hosted inside of a SharePoint Server 2010 document library. This particular excel document has a ODBC data connection to an access database, where the access database ...
0
votes
0answers
20 views

Combine excel workbooks via pivot table/chart?

I have created a site that has 5 workbooks all the same column headings. They have macros and validation within them and therefore cannot be viewed within Sharepoint but must be opened within Excel. ...
0
votes
2answers
411 views

ECB “Edit in Microsoft Excel” is missing for users

I have bunch of user in a SharePoint group with Special Contribute access (same as contribute permission but No delete). These users are not seeing "Edit in Microsoft Excel" in the ECB menu. If I log ...
0
votes
1answer
278 views

SharePoint 2007 List export to Excel 2007

Good Morning, I exported the contents of a SharePoint list to an Excel worksheet; however, I noticed the colors and formatting that have been applied to the data. This was done automatically as a ...
0
votes
1answer
46 views

Search excel spreadsheet or Microsoft access within sharepoint

I have a spreadsheet with a list of batch jobs. I was wondering if it's possible to create some type of search into a sharepoint to search this spreadsheet. We are using sharepoint and if I could have ...
3
votes
0answers
1k views

We cannot locate a server to load the workbook data model

This is the error that appears when I try to refresh data. I have been struggling with this issue for a few weeks. Researching in internet but with no luck. My sharepoint site is 2013 and SQL Server ...
5
votes
1answer
3k views

Adding document version number on Excel Spreadsheet as label for printing purpose

I have a situation where I need to have version number on each document in version controlled document library. Having version number on printed sheet would help to see the validity of document. I ...
0
votes
1answer
45 views

Link Excel to SharePoint 2010 list content

I have an Excel document that is linked to my SharePoint 2010 list. Recently my list climbed over the 5000 limit so I had to add some filtering to my view. This negatively impacted my Excel document ...
0
votes
0answers
651 views

Excel File Opens as an Offline Copy

For some reason, when I check out or open (Read Only) this one Excel file in a document library, it opens as an "offline copy". The File menu in Excel says it's an "Offline Copy: Workbook is in ...
0
votes
2answers
774 views

Excel web part from list - Autorefresh

I am using SharePoint 2010. I currently have a list that gets updated many times throughout the day. I currently have an Excel Web Part with graphs and summary tables on the first tab, and its data ...
1
vote
0answers
21 views

Having issues looking at all old versions

I've been trying to look at older versions of a file but keep getting this error? Any idea what it's happening? I've looked at the source of the document within Excel and it's looking for a copy ...
0
votes
0answers
105 views

Document properties not updated when creating a new document into a XLS templated library

I am replacing a colleague for the support of a SharePoint 2010 intranet. I have got an issue when creating a document into a library. The document template of the library is a XLS file (Excel 97 - ...
0
votes
0answers
260 views

Some Excel documents do not open in Excel 2010

I have a problem with .xlsx files in SharePoint 2010. When I, or other users, try to open Excel files in Excel it just says Downloading: https://server/site/library/file.xslx The document never ...
0
votes
1answer
34 views

Co-authoring in Excel, OWA

After installing Office Web application in my SharePoint server 2010, we are unable to co-authorise with Excel. But this co-authorise function works with Word and PPT. Is there any setting we need to ...