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

learn more… | top users | synonyms

2
votes
1answer
663 views

Export to Excel for sharepoint 2010

Export to Excel was previously not working for clients that were using Office 2007 because we are using claims-based authentication. A few days ago, a few clients noticed that the export to Excel ...
1
vote
1answer
1k views

Most “full control” users can't access datasheet view or export to Excel

All but the administrator users with "full control" and/or "contribute" permissons on a certain list do not recieve the datasheet view option, and when they try to export to Excel there is a ...
1
vote
1answer
26 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 ...
1
vote
1answer
471 views

Importing values from a SharePoint Calendar to Excel form

My company runs EMS Service for private parties, sports events etc. We are scheduling our tasks with a SharePoint calendar. For each event one has to create a Excel sheet containing time, date, task ...
0
votes
2answers
81 views

Mail Merge with Excel Document stored in SharePoint

We have an Excel Document we would like to use as a source file for a Mail Merge in Word. When we open the Excel file in the mail merge wizard we receive the following error. "Sorry we couldn't ...
0
votes
1answer
658 views

Export SharePoint list to Excel - How remove column Item Type and Path

When I export a SharePoint list to Excel using the built-in functionnality, it also exports two columns called "Item Type" and "Path". Is there a way OOTB or programatically to exclude these columns ...
0
votes
0answers
12 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 ...
0
votes
0answers
45 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
1answer
784 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 ...
1
vote
1answer
617 views

Import Sharepoint list via VBA in specific view

I am currenty trying to import a Sharepoint list in an Excel sheet via VBA and thanks to this: Import Sharepoint List into Excel Using VBA Only It is working pretty well, but if i leave the "VIEWNAME" ...
1
vote
1answer
745 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 ...
3
votes
1answer
1k views

“Check Out” button not appearing in Excel 2010

One of my coworkers has this problem for some of the files stored in a document library. If he clicks on the link, from the document library, the dialog has these two options: "Read-only" and "Edit" - ...
1
vote
2answers
549 views

create Content Types like Excel,PowerPoint,One Note documents for document library in SP2013?

I want to create Content Types like Excel,PowerPoint,One Note documents for document library in SP2013,by default once enable the content type in Advance settings,we can able to see the Word content ...
0
votes
2answers
2k views

Excel Services data refresh does not return updated data from data source

I have an Excel include some data which from a SharePoint list. This excel is created by using "Export to Excel" button of the SharePoint list form. I created a pivot table in the excel based on the ...
2
votes
2answers
488 views

How to get my deleted columns back in an Excel file, that were exported from SharePoint lists

I have a list in Sharepoint, and I export it to Excel. All fields get exported, so evetything is fine. Then I deside that I for example no longer want the "Modified by" field in the excel file, and I ...
1
vote
0answers
31 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?
0
votes
2answers
1k views

How to import MS Excel data into an exisiting SharePoint List?

Is it possible to import an excel list or excel data into a SharePoint List that has already been created? Not create a new list. I know you can import a spreadsheet which will create a new list, but ...
3
votes
2answers
3k views

SharePoint Foundation [Unable to process the request in Excel Web App]

I am encountering below error msg whenever I try to open excel file (.xls, .xlsx) in SharePoint Foundation 2010 portal. Other Office files such as word, ppt opens correctly without any error but ...
1
vote
1answer
2k views

Creating a link between an Excel spreadsheet and a list

I have a query regarding something I’m not sure is possible. Hopefully somebody can tell me whether that is the case or not. We have an Excel document that we issue to suppliers after an audit, ...
3
votes
2answers
122 views

SharePoint - Embedding Excel using Excel services

We are trying to embed Excel using SharePoint Excel Services and we are getting the following error, We're sorry. We ran into problem completing your request. Please try again in few minutes ...
1
vote
1answer
8 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
25 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
12 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 ...
2
votes
2answers
5k 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
0answers
22 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
15 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 ...
6
votes
1answer
259 views

Export to Excel adds  to currency field in sharepoint 2013

I am trying to export the data to .xls file using below code GridView2.DataSource = dt; GridView2.DataBind(); DirectoryInfo dir = new DirectoryInfo(@"C:\New List Reports"); ...
1
vote
2answers
33 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
19 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
40 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
1answer
4k views

Add and Update Single Item in Sharepoint List via VBA

I am trying to add and/or update single items in a SharePoint list via VBA and I found a similar question: But I have to say that I can only delete items with this code and I am not familiar with ...
0
votes
2answers
5k views

Trouble opening Excel Document

I have Microsoft Excel 2007 and am trying to open and edit a document from my Employer's SharePoint (I am not sure what version of SharePoint they are running, unfortunately). I have attempted to ...
0
votes
1answer
18 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 ...
1
vote
2answers
39 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
11 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 ...
2
votes
1answer
1k views

Automatically Import Excel Data to SharePoint List

This question has been asked before but I haven't found an answer that works for me and my limitations. I have an excel spreadsheet that is currently being used to input data with 20+ records each ...
0
votes
1answer
33 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
31 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
0answers
43 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 ...
3
votes
4answers
18k views

possible ways to import an excel spreadsheet to a sharepoint 2010 list?

I am running SharePoint Server 2010 and I have an excel spreadsheet of about 3000 rows / 30 columns, which I would like to import to a SharePoint list. I've seen on codeplex a free tool for MOSS/wss ...
0
votes
0answers
27 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
11 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
0answers
8 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 ...
4
votes
1answer
2k views

Export to Spreadsheet option missing from Actions in SharePoint 2013

I am unable to export a SharePoint List (Survey) to a spreadsheet. The option "Export to Spreadsheet" is missing from the Actions dropdown menu for the list. I've done lots and lots of searching for ...
0
votes
2answers
43 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
17 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
16 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
27 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
3answers
242 views

Why does this multi-field validation forumula work in Excel but not in SharePoint 2013?

Why does my simple formula work in Excel but not-work in SharePoint? Why does this formula... =IF([Request Type]="Review",(IF(ISBLANK([Request Date]),FALSE,TRUE)),TRUE) ...work in Excel but fail ...