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

learn more… | top users | synonyms

1
vote
1answer
27 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
46 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
13 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
36 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
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
28 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 ...
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 ...
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
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 ...
0
votes
1answer
43 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
12 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
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
34 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 ...
0
votes
1answer
34 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
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 ...
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
0answers
14 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
20 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?
0
votes
1answer
98 views

the table contains a string that is too long for excel to display. if you edit the long value some data might be lost

I have a SharePoint document library. On exporting to excel I get an error message the table contains a string that is too long for excel to display. if you edit the long value some data might ...
0
votes
0answers
15 views

Linked Excel to Access and then to Sharepoint

I don't know if it's possible, but I'm asking the question anyway. I have a "master" Excel file where the data is located. The "main" interface is quite complex. Basically, it's a calendar to keep ...
0
votes
1answer
14 views

How to add the Excel file in the page on the Sharepoint 2010 foundation?

I would like to insert an excel file into the Sharepoint page on SP 2010 foundation. I saw we can export list to excel, so that I think maybe we can display the excel file in the page. In SP 2010 ...
0
votes
0answers
15 views

Subscription on Excel files in SP 2013?

I administrate a SharePoint 2013 site which is mainly for business reports (.rdl files). Standard SSRS (reporting services) allows you to create subscriptions for these files, but I would like to be ...
0
votes
0answers
24 views

Append Excel data in Sharepoint list

I would need to append data from an Excel template to a SharePoint List. I explain better. Every day employees will open excel template, they will fill in the data and then I will need to append all ...
1
vote
0answers
16 views

Link Access to a SharePoint file whose name keeps changing

I have an Access database that I would like to link to an Excel file located on SharePoint. Normally, this is easy to accomplish as SharePoint/MS Office are well integrated. The problem is, the Excel ...
0
votes
0answers
12 views

“Continue Interacting?” Prompt

We are hosting excel files in sharepoint (with an Office Web Apps server) The users get the below message if they don't interact with the excel file after a few minutes. Is there a way to increase ...
0
votes
1answer
31 views

Lookup column added to list created by importing Excel spreadsheet not working

I have a list on a site that was created by importing an Excel spreadsheet. I have several lookup columns that were deployed to the site using a feature. Going into the site columns gallery, I see ...
1
vote
0answers
48 views

Can't crawl Excel 2003 files from SharePoint 2013

I have a SharePoint 2013 farm and am crawling the contents of a legacy SharePoint 2007 farm on the same network domain. I am getting the following error crawling Excel 2003 files (i.e. xls format) ...
0
votes
0answers
29 views

Using mail merge with word 2013 to get data out of excel 2013

We want to use mail merge in a word document which is saved in a sharepoint 2013 document library. If we try to connect to an excel sheet which is also located in the same document library, we get the ...
0
votes
1answer
20 views

Surveys with Export to Excel option

How do I ensure that once I create a survey in SP 2010 that I'm able to export the resposes to Excel?
0
votes
1answer
69 views

Connect SharePoint Lists with OData

I have a DataSet, I have created an Excel spreadsheet using OData connection. Now I want to create a SharePoint List using this Excel data. I want the Excel and SharePoint List to be sync so that list ...
0
votes
0answers
12 views

Formatting issues when uploading excel tables

I am uploading an excel table with 4 columns to a sharepoint list. The first three columns are text, and the last column numbers. When I go to upload, it says that the middle two columns will be ...
0
votes
1answer
56 views

How to handle Excel sheets with macros

We have an Excel sheet with Macros on it. We uploaded the Excel sheet into SharePoint Document Library. When the Excel is opened using Excel Online, Macros do not work. So in order to make Macros work ...
0
votes
2answers
82 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
2answers
75 views

how to export the data from a webpart to excel and pdf in sharepoint 2010

I have a custom Web Part which retrieve the data from SQL Server 2008 manipulates it and shows the data table in UI. Below is the UI of the data on the Web Part. The data contains URLs, Dates, Names ...
0
votes
1answer
83 views

Force a document to open in the application and not the web app?

I have a large Excel file (under 1 meg, but almost 25 tabs) that none of my users can open in Excel Online. If you click on it in the document library, it spins for a while before giving this error: ...
0
votes
0answers
16 views

Checking In Edit in Excel document not updating quickly

A user was reporting that when they were editing and checking in files, they weren't showing up. I created a file in this library and this is what I found: Check Out Edit in Microsoft Excel Add ...
0
votes
0answers
47 views

PowerView Export to PowerPoint Functionality in Office 365

I am looking to be able to export a PowerView document to PowerPoint but cannot seem to find that functionality in the latest release. I am using Excel 2013, latest updates, and a SharePoint Online ...
0
votes
0answers
29 views

HTTP request on lists.asmx GetVersionCollection method

While looking for a HTTP REST method to return Document Version History, I stumbled on the GetVersionCollection method. However, I have not found any syntax showing how to make the call from a ...
0
votes
1answer
22 views

How to add SSAS excel report on SharePoint page?

We have a Excel Sheet which has got a Chart that is generated from an Analysis DB (Excel connects to Analysis DB with a particular credential which is setup when connecting to Analysis DB via Excel). ...
0
votes
1answer
23 views

How many webparts are available in SharePoint for displaying an excel sheet/excel report?

We are doing some R&D on displaying excel sheets (simple sheets with no external data connection) and excel reports(which connect to sql db) on a SharePoint page. I would like to know what are ...