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

learn more… | top users | synonyms

0
votes
2answers
470 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
34 views

SharePoint 2010 & Excel Services & Errors

Good Evening All, I've been trying to configure automatic data refresh on excel spreadsheet that's hosted within an Excel web part. My spreadsheet pulls data from a SharePoint list into a pivot table ...
0
votes
0answers
23 views

Cannot Copy and Paste in SharePoint 2007 datasheet view

I currently have office 2013 and I have been copy and pasting into a datasheet view list for SharePoint 2007 for a long time. All of a sudden I cannot paste any values into my list. the load wheel ...
1
vote
2answers
2k views

'Export to Spreadsheet' error

I'm working with WSS 3.0 and have access to a number of sites within SharePoint. I and a number of other users have run into an issue that is happening when we try export a list using the "Export to ...
0
votes
0answers
108 views

How to get the Last Modified Date and Time of an Excel file in a Sharepoint using VBA?

i am creating a macro file with command buttons that when you click it, it will display the properties esp the last modified date and time of an Excel file uploaded in a SharePoint site. How can i do ...
2
votes
2answers
258 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 ...
0
votes
1answer
358 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 ...
2
votes
3answers
1k views

List containing Managed Metadata when exported to Excel using Ribbon, has weird hash tags - how to clean?

I have a calendar All Events list which contains few fields, some from Managed Metadata and People presence lookup fields. When I try to use the Ribbon feature to export the list into an Excel, each ...
0
votes
1answer
21 views

Limit users to their own employees

I have a list of about 1000 employees with their addresses and phone numbers which I want to upload to a 2007 SharePoint in list format, which I know how to do, however due to data protection, ...
0
votes
0answers
105 views

Creating a file via VBA leads to Check-in Stalemate

We have Sharepoint 2010 Enterprise. I want to create a series of workbooks for salespeople, each one personalized, and with a different name . I want to have check-out enabled on the target doc ...
0
votes
0answers
30 views

problem with exporting sharepoint 2007 list to excel spreadsheet

I have a user who wants to be able to export data from a document library to a spreadsheet. This should be a simple matter of clicking the actions menu and selecting 'Export to Spreadsheet' and when I ...
2
votes
1answer
52 views

Embedding an Access database in SharePoint?

I have a client who would like me to embed an access database from another location (document library) to a SharePoint page in an editable format. Similar to how you can add the "Excel Web Access" web ...
5
votes
1answer
3k 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
54 views

How To Create An Excel Type Grid Application In SharePoint 2010

I have a requirement to create an application in SharePoint 2010 where the user interface presented is like a grid/spreadsheet. But each cell in the grid needs to represent a SharePoint item in a ...
0
votes
2answers
39 views

Show SharePoint columns in Excel sheet

How can one show columns from a SharePoint document library into an Excel sheet. Properly with VBA, but I don't now how?
0
votes
0answers
306 views

How to avoid authentication prompt when opening XLSX document on anonymous site?

I have a SharePoint 2013 that is setup in anonymous mode (at the web app level and then at the site level; the Entire Web site is being exposed as anonymous). I then have the "lock-down mode" feature ...
0
votes
1answer
36 views

Excel Cell Link to InfoPath sending data to SharePoint

I want to be able to send out an Excel file with a list of clients and use that file to be able to open up a form when they click on a client. The form would be pre-populated with information from ...
0
votes
1answer
15 views

ExcelWebPart Issue

I'm using ExcelWebpart in my page and I defined permissions on the webpart. Some users can edit the excel webpart. They click "OPEN IN EXCEL" and then they can edit. But today when they click on the ...
5
votes
1answer
2k views

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

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 is as follows: "We can't do that because the ...
1
vote
4answers
2k views
0
votes
0answers
21 views

Syncing Sharepoint 2013 List from Excel 2010 spreadsheet?

So i'm trying to figure out a way in which I can append items within my SharePoint list by inserting the data from an Excel Spreadsheet. However, the SharePoint list has additional columns which are ...
2
votes
2answers
4k views

Working with data imported from Excel into a SharePoint List

I just imported an Excel spreadsheet into a SharePoint list, and all of my data was imported as single or multiple lines of text. While appropriate for some instances, in other cases, like a name ...
6
votes
0answers
193 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
1answer
271 views

How to connect an Excel file to a Data Connection Library?

In the article here, it states that an excel file can connect to a .odc file inside a DCL. I've researched for a bit and finally stumbled upon a solution that involves having to modify registry ...
1
vote
2answers
329 views

Link on wiki page to Excel document that opens in Excel Online

On a wiki page, I would like to create a link to an Excel document stored in the Documents folder on SharePoint, that opens the Excel file in Excel Online. When I create the link using Insert -> Link ...
0
votes
0answers
21 views

SharePoint 2013 online List export to excel with views as worksheets

I have a client that would like to export a SharePoint List to Excel but to also include the views as the worksheets. How would I go about implementing this? Is this even possible? The data would ...
0
votes
1answer
184 views

Excel Linked Cells

I have the following use case: Two Excel documents are stored in the same folder on a shared drive (a typical SMB Share). The workbooks are linked through a single linked cell. If you open both ...
3
votes
3answers
3k views

How to create an auto-updating chart from a Sharepoint list

Is there a way to create a chart/graph from a Sharepoint list, whether through Sharepoint graphing or MS Excel, so that the chart will automatically update when the data in the list changes? I've ...
0
votes
0answers
69 views

Error when trying to reference an excel sheet inside SharePoint document library “The file name, directory name or volume label syntax is incorrect”

I have the following :- SharePoint document library. Inside the document library i have; Visio diagrams + excel sheet. now i am using an Add-in inside the Visio drawings to reference the Excel sheet ...
0
votes
1answer
21 views

Alternative ways to read excel in Sharepoint

Now I'm facing with a problem of reading excel file on SharePoint server. In the old ways I usually use the OLEDB to read excel through the connection string, but it's just work on 32 bit system, ...
1
vote
2answers
234 views

Excel services refresh using Claims based NTLM?

I am able to upload reports in a sharepoint library that have embedded data connections to a cube(SQL2008\AnalysisInstance). We are not using power pivot. We are running Sql 2008 standard version. ...
0
votes
1answer
70 views

SharePoint Exports to Excel, can't I get directly in .xlsx file?

I am using SP 2013 foundation. I am able to export list into .iqy file. Which is good. But users wants directly .xlsx or .xls files. Is it possible to do that?
0
votes
1answer
9 views

Convert Sharepoint webpart 2013 to 32 bit version

Are there any ways to convert the visual webpart to 32 bit version. I have target in the property project c#, but I couldn't add the webpart to page. What I meant is in my case: I open excel file by ...
0
votes
1answer
261 views

Open a link of Excel with the dialog popup window in quick launch SharePoint 2010

I have a Excel document in the Library SharePoint 2010. And I set "Open in the client application" in Library setting. Every time I open this document, there is a popup window with a question "How ...
0
votes
2answers
2k views

Sharepoint 2013 pasting text into a cell of multiple lines type

I am trying to copy & paste a cell of data from excel to my sharepoint list. The excel cell of data consists of multiple lines of text, so when I copy & paste in the data it pastes it onto ...
0
votes
0answers
9 views

Excel Services Problem

one of our client was adding Excel access webpart to his site and when he clicked on Edit webpart properties, he is not able to see all the properties of Excel access webpart which he should see. When ...
0
votes
0answers
79 views

“Open In Excel” button inside the Xlviewer.aspx page return Error and I can not open excel using local office

Inside the xlviewer.aspx page of sharepoint 2013 when I click on "Open In Excel" at first I receive this Error: Some files contain viruses that can be harmful to your computer. it is important to be ...
0
votes
0answers
25 views

Give Permissions to the Excel WebPart

I created a new webpart page with ExcelWebRenderer. I want to give edit permission to a group for the excel page. Other persons have read only permission for this excel page. I created a group and I ...
0
votes
1answer
75 views

How do I have a workflow update a field/column in the current list(InfoPath created list)?

I have a column with this formula: =YEAR(Created)&"-"&(ID) , the YEAR(created) part works as intended but the ID part doesnt. It often shows only 2014- but it should show 2014-50, the 50 beign ...
0
votes
0answers
10 views

Copying part of Excel workbook to a different workbook in SharePoint 2010

I have a rather simple task, at least by the description. Let’s say I have a File A (xslb) on SharePoint A and I need to copy out some data from File A to File B. File B is xslx document on a ...
0
votes
0answers
27 views

How to export SharePoint 2007 AD Accounts to Excel

Is there any way to export SharePoint 2007 AD accounts to Excel? I know that there are couple of ways to export SharePoint Userinfo list to Excel. But i want to export SharePoint 2007 Active Directory ...
0
votes
1answer
20 views

Display a Excel Chart

I'm using sharepoint for my team, and i would like to dispalay charts which update daily from my data connections. Currently i use a images and update daily, i want to automate this by hosing the ...
0
votes
1answer
576 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
1answer
28 views

column formula help

I've asked a question a couple days ago, wich gave me the answer =IF( OR(INT(A)+INT(B)+INT(C) = 3, INT(A)+INT(B)+INT(C) = 0), "Accepted", "Not Accepted" ) But that only works if they have to fill ...
0
votes
2answers
5k views

Exporting SharePoint Members into Excel

Is there a proper way to export a group of sp group members into excel? I have been able to select a group from permissions and export them into excel. The problem I face was that even when I ...
0
votes
2answers
166 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 ...
2
votes
2answers
36 views

Sharepoint formula limit help

i've been making this formula(based on previous questions) which works great(with 3 id's), But when i try it with all my id's it give me an error "Cannot complete this action". Can anyone help me out? ...
2
votes
1answer
72 views

help Column formula in sharepoint list

So i asked this question a couple hours ago: I have made a list with InfoPath in SharePoint. All the questions are either "accepted" or "notaccepted" (radiobuttons) and I want to make a new column ...
0
votes
1answer
521 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. ...
1
vote
0answers
54 views

Connectivity issue from Excel 2010 to SharePoint

We are using Excel 2010 and was running in Window XP. Connectivity with SharePoint was good. Recently our environment got migrated from XP to Windows 7. Until that point we are seeing the following ...