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

learn more… | top users | synonyms

0
votes
1answer
74 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
201 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
2answers
1k 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
114 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
3k 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 ...
0
votes
1answer
63 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
1k 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 ...
1
vote
0answers
24 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
1answer
35 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 ...
2
votes
0answers
60 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
0answers
290 views

Cannot Save Excel to Sharepoint

One of my users is having an issue saving to Sharepoint with some very specific parameters. the problem is related to saving only from within excel if a document has been opened from SP. She is ...
0
votes
0answers
821 views

Export Excel Table to Sharepoint List throwing publishing error?

I have a SP Foundation 2010 installation on windows 7. I created a OOTB Contacts list in SharePoint and tried exporting an excel (Office 365) table with various fields to this list. Note: The column ...
1
vote
1answer
274 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 ...
1
vote
1answer
423 views

Why does SharePoint 2010 Excel WebPart not find Excel spreadsheet in Share Documents?

I have a SharePoint 2010 single instance. The Web site has an Excel worksheet in Shared Documents, which I can navigate to as a user. I have enabled Excel services. I have activated Excel services ...
1
vote
1answer
339 views

IF AND CONCATENATE Nested Statement in Calculated Column SharePoint 2010

I am having trouble nesting concatenate formula with if statement - syntax error. I am trying to create a calculated column. This column will list "master file" string if exist. If two master files ...
1
vote
1answer
129 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
291 views

Export all of Sharepoint 2010 data (list, webapp data, etc. )

I need to export all of Sharepoint 2010 data (list, webapp data, etc.) in to a easy to import file. Meaning I have "SiteName" with lists and webapp data, and I need all the information of that site in ...
0
votes
1answer
307 views

Sharepoint 2010 / Google Chrome / Excel

From one of our users: Now that many of the items seem to work with Sharepoint and Chrome, one of the biggest outstanding issues is that it wants to open the documents in the browser by default. ...
0
votes
1answer
118 views

Read from an excel Sheet and write to a List

My requirement is that, i need to upload data from an excel sheet to an existing sharepoint List in SP 2010.I will have 2 different Lists Like this. Then I need to compare Both the List and retrieve ...
2
votes
1answer
694 views

Document Library containing Managed Metadata when exported to Excel has weird characters

We have document library for storing assets in it. Document Library contains some of Managed Metadata lookup fields. When I try to use the Ribbon feature to export the list into an Excel, each of the ...
1
vote
0answers
41 views

Sharepoint 2010 issue with exporting certain combination of columns from a view

so I am encountering an issue where I am trying to export to excel..I modify my default view to include all the columns I need in the export. When I try to export, it's either hit or miss with certain ...
1
vote
0answers
191 views

SP2103 Excel-Services Freeze Panes / Headers

Do anyone know a simple solution to freezing the headers in an Excel file that is published on a SharePoint 2013 portal.
1
vote
0answers
181 views

Enable Publishing Options button without SharePoint Designer

We use MS Office 2010 Standard, and some users will be publishing spreadsheets from Excel to SharePoint (2010). We have discovered, however, that the Publishing Options button only appears in the Send ...
1
vote
0answers
19 views

How to link Excel to Acces when the files are saved on sharepoint, then refresh in Excel service

We have files in excel that are saved on sharepoint. We want to pull this into access, but when trying to link to them from access, we get a an error that they must be XML files. How can i link ...
1
vote
2answers
4k views

query a sharepoint 2010 list from excel vba to retrieve a specific record

I have created a SharePoint 2010 list with 2 relevant columns: - Identification Key - Version Number I want to be able to query this SharePoint list from Excel VBA - passing the Identification Key to ...
1
vote
1answer
34 views

Displaying Version # In Document

I am looking for a way to display the SPItem version number from within an Excel document. We are authoring an Excel Template in a version controlled document library. I want the Excel document to ...
2
votes
0answers
156 views

Data truncated when pasting worksheet into multiline field

I'm trying to paste the contents of an Excel sheet into a list in Datasheet view. This list has several multiline columns, and the Excel data items i'm trying to paste in are quite large--in some ...
4
votes
1answer
2k views

Error while opening sharepoint list in datasheetview and exporting to excel

I have a List which is having around 14000 items in it.while opening that list in datasheet view it is giving error . Below is a summary of the issue: After selecting datasheet view : "Cannot ...
0
votes
1answer
332 views

Error exporting list to excel - permissions for resource throttling ceiling

What level of permissions have to be assigned to a user account in SharePoint 2010 for them to qualify as an "administrator" and therefore grant them access to the higher ceiling for resource ...
2
votes
1answer
430 views

Saving an Excel file: You do not have the correct permissions. Contact the server administrator

A user is attempting to open an excel file from a SP 2010 library, make edits, and save it back. when clicking save, he gets this error message in a popup window: You do not have the correct ...
0
votes
0answers
179 views

SharePoint 2010 List Excel Export Error

I have some problems about exporting a SharePoint List to excel. I'm getting "Excel cannot connect to the SharePoint list" error while exporting it to excel. There wasn't any error in the same list ...
1
vote
1answer
3k views

Documents Not Prompting to Check Out and Not Saving

I am getting strange behavior on some of my users machines when they attempt to edit an Excel workbook from SharePoint. When the user clicks on the document link it opens the workbook in Excel and ...
0
votes
1answer
37 views

Open documents in client unusual behavior

I recently modified settings at the list level to force documents to open on the client. After I tested the behavior while logged in as an Admin and it seemed to work fine. Today however an end user ...
3
votes
3answers
19k views

Excel document opening in browser (unsupported features)

I am using Sharepoint 2010 and when users click on an .xlsx document in a document library it says the following: "The workbook cannot be opened because it contains the following features that are ...
2
votes
3answers
6k views

Is there a free sharepoint hosting site where I can try out Access 2013 asset tracking template?

Is there a free sharepoint hosting site where I can try out Access 2013 asset tracking template? I just want to see how it works.
1
vote
2answers
2k views

Fail to export custom SPList to Excel

Im trying to export a SharePoint-List(created from a custom Listdefinition) to Excel by using the "Export to Excel"-button on the ribbon. It works when im trying with other default SharePoint-lists ...
0
votes
2answers
29 views

French excel numbers being changed to english when uploaded to SharePoint, how to fix?

I have a site where I've uploaded an excel document that was translated by one of the companies we use and once I uploaded it to my SharePoint site but the column that contained numbers changed to ...
2
votes
2answers
5k views

SharePoint 2010 error when importing excel spreadsheet to sharepoint list

I get the following error when trying to import an excel spreadsheet into a SharePoint list. "The specified file is not a valid spreadsheet or contains no data to import" I have added this site to ...
1
vote
1answer
4k 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) ...
2
votes
1answer
54 views

Creating lists within lists, or tables within lists, or…?

I have just started working with a company on a variety of different IT issues, mostly Sharepoint 2010. They are going to contract a Sharepoint developer to help with a problem they have been having ...
1
vote
2answers
368 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
177 views

Use an Access Web Database as a data source for Excel?

I have an Access 2010 Web Database published to SharePoint as described here: http://office.microsoft.com/en-us/access-help/build-an-access-database-to-share-on-the-web-HA010356866.aspx If my Access ...
0
votes
1answer
327 views

How to convert Sharepoint 2010 Chart web part to Excel?

I want to convert chart webpart's chart to excel format how it is possible?
1
vote
1answer
2k views

Unable to refresh data for a data connection in the workbook.

I am trying to use an Excel Web Part that connects to a list in Sharepoint 2010. On my local drive the spreadsheet updates when I open it and all is well but when I uploaded to sharepoint the data ...
1
vote
1answer
310 views

If a user can't read Excel file, can they still view Chart Web Part created from it?

Title sums it up. I would just try it myself but my test environment is down and I figured I might get a speedier response here than to wait for that to come up. If users don't have permissions to ...
2
votes
4answers
21k views

Excel links open files as read-only mode. How to change this to edit mode?

Does anyone have any idea why using the link on excel opens the file as read-only mode? How can I change the behavior to open as Edit mode? I checked almost all of the Document Library settings, ...
2
votes
1answer
3k views

SharePoint List Export to Excel All Columns!

As you may know SharePoint's default export to excel only exports the columns of that current view to excel. Is there anyway to export all columns, without adding all columns to that current view.
0
votes
1answer
1k views

How to modify an Office (Word, Excel) file in sharepoint programmatically

I need to Open and modify a document that resides on a Sharepoint Document Library. These changes on the file are done during an event generated by a Document Library, so I must change it by code. ...
1
vote
0answers
25 views

Import excel spreadsheet with photos

I am trying to import an excel spreadsheet with photos, It import without problems, except that it removes the photos. What am I doing wrong?
0
votes
0answers
60 views

Sharepoint link issue

I am having a weird issue. I uploaded an excel document to sharepoint, and when I click the link it does not do anything, however if I right click open in new tab it opens. ** This is an excel ...