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

learn more… | top users | synonyms

0
votes
0answers
13 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
247 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
27 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
17 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
23 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 ...
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 ...
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 ...
0
votes
1answer
593 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 ...
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 ...
1
vote
1answer
585 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" ...
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 ...
1
vote
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" - ...
0
votes
1answer
750 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
712 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
2answers
476 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
1answer
27 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
16 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
18 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
24 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
9 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
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 ...
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 ...
0
votes
2answers
879 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 ...
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
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, ...
0
votes
2answers
40 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
14 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
15 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
21 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
224 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 ...
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
0answers
11 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
66 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
1answer
918 views

Getting fully qualified FieldUserValue instead of actual user name from SharePoint

I'm working on my first C# program, and it's a pretty simple program that uses a view of a SharePoint page to go through and delete things that are older than 5 days on that page. Before deleting the ...
0
votes
0answers
9 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
12 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
12 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
17 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
11 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
1answer
22 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 ...
0
votes
3answers
231 views

Files downloading instead of opening in Chrome

User is accessing SP through Chrome (rest of us have IE). When they click on a spreadsheet they don't get the usual prompt to select read only/edit mode. The spreadsheet opens and they make their ...
0
votes
0answers
11 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
0answers
85 views

SharePoint 2013 Excel WebPart

I created new excel webpart. I got this error : The trial period for SharePoint Server has expired. I researched on net and i found this solve : Run--> inetmgr-->Application Pools--> ...
1
vote
0answers
32 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) ...