0
votes
0answers
15 views

Exporting discussion board with all the replies

Is there any way to export a discussion board to Excel with all the replies? I've tried clicking on Export to Excel from the ribbon, but what I get isn't what I want as this does not give me the ...
0
votes
0answers
21 views

Sharepoint list 2010 connecting to excel refresh data

I've managed to export all the files to Excel and upload it to Sharepoint location. This Excel file is used as table of content of all documents that we have in our company. I've also managed to set ...
1
vote
1answer
28 views

Sharepoint List & Export to excel sheet

I read that we can store list items limitation for sharepoint 2010 is 30 million . Is this true ? If yes , then can i have 25 million records in sharepoint list , and use "export to excel sheet" and ...
0
votes
0answers
22 views

HTML tag rotation only rotates dimensions but not text within

I saved an Excel sheet as an HTML file and I needed the header text to rotate 270 degrees. I made it work on all browsers while I edited and tested only as an independent HTML file, but when I added ...
1
vote
1answer
52 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
33 views

Excel document opening in web view even though default is to open in program

I have a document library with one Excel spreadsheet in it. The document library's settings are such that the spreadsheet should be opening in each client's Excel program, not in Excel Web View. I ...
0
votes
0answers
42 views

Export to Excel is slow

I am working with SharePoint 2010 / 2013. Very often I have to export large lists (>1000 Items) to Excel. This always takes some time (e.g. about 3 Minutes for 3500 list items). Is this normal, or ...
0
votes
0answers
8 views

Loss of formulas when using excel to move sharepoint lists

I need to move a list in Sharepoint 2010 from one site to another. I have tried doing this by (1) saving original list as an excel worksheet and (2) creating a new list from that worksheet. The ...
1
vote
1answer
99 views

Since last patch, unable to open excel documents and word documents can only be opened by dropdown

We performed updates to the SharePoint Portal, SharePoint Foundation, Office Sharepoint Server, Excel Services Component, and Word Server on 03/16/2014. Since then, we are unable to open Excel ...
1
vote
1answer
182 views

Excel document not updating on open

I have an excel document that is linked to a SP 2010 list. I set the connection and the update on open. It works just fine (i.e. updates with new data) when the file is on my local machine. However ...
1
vote
1answer
36 views

Windows 7, excel and word 2010 how get RID of Sharepoint popup window? [closed]

When using Excel (and possibly Word) this irritating popup window appears requesting some kind of password. I want to get RID of this window and get rid of Sharpoint, whatever it is.
0
votes
2answers
176 views

SharePoint list not accepting copied excel data

Hello I am having an issue with a SharePoint list not accepting copied data from an excel sheet while in datasheet view. The sheet has 130 rows of data I have done this before and made sure the ...
0
votes
0answers
152 views

Can't connect to sharepoint for data refresh since upgraded to Excel 2010

I use Microsoft Enterprise Project Management (EPM), which is based on SharePoint Services and started having problems after upgrading my local machine Office from 2007 to 2010. I can normally ...
1
vote
2answers
95 views

Merging excel documents similar to slide libraries

I have a scenario that would be perfect for slide libraries - but they're excel sheets. We use SharePoint 2010. Also, I do not have access to the server itself... Just site collection administrator. ...
2
votes
1answer
193 views

Cannot retrieve all items from large SharePoint list via Excel data connection

I have a large SharePoint 2010 list (~60,000 items) in which the list view threshold has been turned off. Recently, we've encountered the problem that exporting the list to Excel only yields a subset ...
0
votes
1answer
31 views

In Excel, OnClick I need to save then add a workbook to a SPT 2010 Standard Edition doc Library? How to do this?

I am not a coder, but I have seen VB scripts that "kind of" does this.. I'm willing to try (nervous smile). I need to add a button in an Excel workbook that will "auto upload" the workbook to a ...
0
votes
2answers
569 views

Rich Text field in Infopath customized form adds blank lines in Excel

I have a fairly basic custom list in Sharepoint 2010 which contains a rich text field. I have customized the form with Infopath. Now when I export to Excel I find blank lines preceding the text. ...
0
votes
1answer
65 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 ...
0
votes
0answers
23 views

Combine excel workbooks via pivot table/chart?

I have created a site that has 5 workbooks all the same column headings. They have macros and validation within them and therefore cannot be viewed within Sharepoint but must be opened within Excel. ...
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 ...
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 ...
1
vote
1answer
232 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 ...
0
votes
1answer
238 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
107 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 ...
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 ...
0
votes
1answer
295 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 ...
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
16k 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 ...
1
vote
2answers
355 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 ...
2
votes
1answer
2k 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 ...
3
votes
1answer
113 views

Can someone help me use SharePoint 2010 to do data processing?

TL;DR: I need to create a system in SharePoint in which a user uploads an Excel (or CSV) file to the site from a webpage. The site takes the uploaded document and uses it to populate a list. Then it ...
0
votes
1answer
87 views

How to refer to a local file for a PowerPivot datasource?

We have users trying to use Performance Point and need to point to a local PowerPivot file as a data source. The instructions state: Type the connection string to the PowerPivot data source by ...
1
vote
0answers
978 views

Unable to check-out an excel sheet from a document library in SharePoint 2010 Standard

I have a document library under my SharePoint 2010 Standard site. We are uploading Excel files to this document library to be updated by multiple users (Using Check-in/Check-out). We are using IE9 as ...
0
votes
1answer
1k views

Simultaneous working with Excel in SP2010

Is it possible to work with multiple users simultaneous on the same excel document in SP2010? If possible without the excel web app. Extra... Is it possible to work with different versions then? ...
1
vote
1answer
2k views

Having trouble check in excel file in SharePoint 2010

I tried to check in the file to the site. But I got this error message (The system cannot find the file specified (Exception from HRESULT: 0x80070002)). I'm able to check out the file, edit, and ...
2
votes
2answers
957 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 ...
2
votes
2answers
3k 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 ...
1
vote
1answer
1k views

SharePoint 2010 Issue with CSV File

We are using SharePoint 2010. I have permission (full access) on my site. I have three uploaded files (one Word .doc, one Excel .xls, one CSV .csv). I had no problems editing Word and Excel files. ...
0
votes
1answer
882 views

How to manage a dynamically updated Excel file in SharePoint

When we have a client that requests a call back, we fill out a web form that automatically populates an excel spreadsheet on a shared drive. Reps will then access the spreadsheet and take appropriate ...
0
votes
2answers
2k views

Open docs from SP2010 in excel/word crashes

I have: SP2010 rented from a company. 1 site collection I have IE 9.0.8 For about a 6 months I have this consistent problem. When I click on a Word doc or Excel doc, I get a choice to edit, I do ...
1
vote
0answers
408 views

Exporting Custom List view in Sharepoint 2010 to Excel

I am creating a custom list view programatically which hides some of the columns in the actual list. But while exporting to excel all the columns are visible. Any tips/help is appreciated.
1
vote
2answers
8k views

Export Survey Results to Excel option not in Action Menu

I have a survey and all the needed results. I need to export the results to excel, though in the process of setting up the survey I changed or removed the Overview.aspx page/view. Now when I add a ...
2
votes
1answer
1k views

Update existing list in Sharepoint 2010 with Excel or Access 2007?

I'm looking for ways to update an existing list in SharePoint by using either Excel 2007 or Access 2007. I have seen plenty of ways to create a new list, but nothing about updating existing lists. ...
7
votes
6answers
22k views

Unable to open office files in Office client

While trying to open an excel document stored in "Shared Documents" library, the excel application opens up with a login prompt, to which I passed the login credentials of the site. After which the ...
1
vote
1answer
525 views

Excel Web Access & VSTO

I created an Excel workbook in Visual Studio 2010 using VSTO, and it fills a table with data retrieved from a WCF service. The service was added to the project using the standard "Add Service ...