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

learn more… | top users | synonyms

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. ...
2
votes
1answer
143 views

Simple Way to Get Data from WSS 3.0 List to Excel via Web Services

Is there any simple way to get live data from a WSS 3.0 list into Excel via web services or am I going to need to write code? I understand I can export the list data, that is far too manual.
1
vote
1answer
524 views

How to update Excel Sheet In SharePoint 2010 (Sharepoint Online)?

I am working with SharePoint Online(Office 365). I have some Excel files uploaded in a SharePoint library and I need to update one of the file data using c# code. My solution in Sandbox solution. I ...
2
votes
0answers
64 views

Writing excel 2003 vba to extract a Sharepoint list to Excel

I'm trying to find some Excel 2003 VBA that will let me inport a sharepoint list into Excel so that I can perform some basic tasks on that data.
3
votes
2answers
6k views

Permission levels for user exporting list into excelsheet sharepoint 2010

What are the minimum permissions needed for a users to export the list into excel sheets in SharePoint 2010?
1
vote
0answers
104 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
48 views

Fact tables indicators selectors/filters in an excel report with pivot tables

I'm working in a project where I need to publish some reports based on excel pivot tables against SSAS cube. Until here everything is OK. However, I want to know how I can set in my excel report a ...
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
82 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 ...
2
votes
0answers
238 views

How to make a List Column link to Excel Cell

I have a SP library that lists the names of various excel spreadsheets. Each spreadsheet has a cell that reflects the percentage of completion for a project. I also have a SP list of projects, which ...
1
vote
2answers
240 views

Ability to migrate linked Excel spreadsheets to MOSS

Hi our finance team have multiple links to other spreadsheets within the current file server. We wish to migrate these to Sharepoint to offer them a solution via Extranet. Is this possible? There ...
2
votes
0answers
398 views

offline and online (SP 2010) version of Excel with slicer

An user uploaded Excel with Pivot that has slicer to sharepoint document library. The data for this excel coming from SQL backend. The browser gives following error. "The workbook cannot be opened ...
1
vote
1answer
250 views

Sharepoint Excel data table and Chart

Need help about sharepoint. I have a table data collection currently in ms excel document look like the following image. every last day of the week the information will be updated (append new ...
0
votes
2answers
182 views

Export SPGridView to Excel tabs

I have multiple SPGridViews on a page. I would like to export them all to one Excel document, each SPGridView on its own tab. Is this possible? This link is a great start but does not solve my tab ...
2
votes
6answers
11k views

Importing an Excel file to a list - how to control the column types

I am attempting to import an Excel file into SharePoint using Create List > Import Spreadsheet. Several columns are just short text fields < 100 chars and with no formatting/line breaks etc. Some ...
0
votes
1answer
208 views

Migrate Excel Docs from Shared Drive to Sharepoint Foundation 2010?

I have a fairly large shared drive with various files that need to be migrated over to SharePoint. I only have full control of my site, which is a subsite within the hierarchy. I feel like if I were ...
0
votes
1answer
5k views

Cannot open file using Edit options

We recently had a few users in our environment upgrade to Excel 2010 and all these users are now experiencing the same problem where they cannot edit files by clicking them in the library or using the ...
0
votes
2answers
61 views

Upgraded SP Servers and now webpart can't access C drive

We had one WFE server and upgraded to 2 WFE servers with a load balancer. We are using the SharePoint Server Standard edition. Because we are using the Standard edition and do not have access to BI ...
1
vote
1answer
1k views

Recovering data from modified infopath fields?

I had built and published an infopath form to a sharepoint library and populated the library with about 50 documents(based on the template) I modified (deletd rich text boxes and replaced it with ...
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 ...
0
votes
1answer
721 views

Tracking Changes to Individual Cell in Excel Spreadsheet on SharePoint?

I've gotten a weird request today, someone I work with asked if there is any way to track changes to a specific cell in an Excel Spreadsheet. The spreadsheet is hosted on SharePoint and they want to ...
0
votes
1answer
120 views

Create Date Field when using Data Connection in Excel

I noticed that the create date field of a list item is not returned when you create a data connection to it using Excel. The technique I am using is to go to the list and export it from the ribbon ...
1
vote
1answer
256 views

Unable to use filter or edit Excel Worksheet while opening from Excel web access?

I am able to view and filter data based off excel fileters via the Excel Web Access web part for Excel workbooks. However, when I "open in Excel" it does not allow me to filter or edit. Note: I ...
3
votes
1answer
2k views

SharePoint 2010 Excel Web Access “Automatically reloading workbook”

I am working with SharePoint 2010. I used an Excel Web Access web part to display an Excel Spreadsheet. So that the spreadsheet can be opened in Excel and people can do editing. However, every time ...
0
votes
2answers
3k views

Sharepoint seeking authentication when opening Word / Excel files from website

The company I work for is using SharePoint as a CMS for it's public facing website. I recently enabled FBA (Forms Based Authentication) for the site in order to provide some user specific ...
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 ...
0
votes
1answer
1k views

Getting rid of the session timeout in Excel Web Access?

I understand there is a 30 second short session timeout (if no interaction is detected) to a 5 minute extended sessiopn timeout. The userss would like their reports up all day, just refreshing every ...
3
votes
2answers
200 views

Row Labels are blank in PivotTable from Analysis Services

I have Team Foundation Server 2010 and SQL Server 2008 SP2 installation and am looking at the out-of-the-box Excel Reports for an Agile project. All of the Excel Reports connect to the TFS OLAP cube ...
1
vote
0answers
288 views

SharePoint 2007 WebPart Event Handling on Custom ASPX webpart page

What I'm trying to do: I've got a custom aspx page that is wrapped in a SharePoint feature in order to get deployed. This aspx page contains 4 (Excel Web Access) web parts that are added dynamically ...
3
votes
1answer
224 views

How to configure Excel and SharePoint to access remote databases

I am using Excel to render data stored in a PostgresQL database elsewhere on our network. In general, the rendering works. However, I haven't been able to get the document to automatically ...
1
vote
0answers
76 views

Need to be able to select on a column that can have one ore more values

I have a column in a sharepoint list that lists the various departments within my company. One or more of these departments can be selected. Since the column does not show up as a selection when I ...
1
vote
1answer
194 views

Edit Document in Sharepoint

I have an issue when editing and save sharepoint Office document. Firstly if I am right clicking on the document and saving it. It is fast and fine. If I try to edit it in office, it opens very slow ...
0
votes
2answers
2k views

Excel Web Access Not Disabled?

I uploaded a spreadsheet to one of my sharepoint 2007 sites. When I click on the link I get the error "Exxel Web Access An error has occurred. Please contact your system administrator if the problem ...
0
votes
1answer
188 views

SharePoint 2007 and Large Excel files

I have a user that has create an Excel file, the file has 16 tabs on it, and 14 of the tabs are graphs and the last two 15 & 16 tabs are pivot table that control the graphs. Tab 15 pivot tables ...
0
votes
1answer
829 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 ...
1
vote
3answers
2k views

Can You Enhance the “Export to Spreadsheet” Action for SharePoint Lists?

Do you know of any resources/solutions to enhance the List’s “Export to Spreadsheet” function so that, once the data is opened in Excel, something would trigger VBA Macro(s) to start formatting the ...
1
vote
1answer
396 views

Is it possible to import an Excel spreadsheet, including the comments and hyperlinks, into a List?

I would like to import a Microsoft Excel spreadsheet into a SharePoint 2007 List. The spreadsheet contains comments and hyperlinks. Could those also be imported in the List? Comments I know would ...
0
votes
2answers
1k views

How to customize SharePoint Chart web part

I want to customize SharePoint chart web part programmatically to display charts from the excel sheet having different charts on different sheets of the excel. How can I customize chart web part so ...
1
vote
1answer
195 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
2answers
228 views

Hard limit to have number of Excel webparts on SharePoint 2010 page?

Is there any hard limit to have number of Excel webparts on the SharePoint 2010 page?
0
votes
0answers
820 views

How to export filtered list data to Excel

I have custom application page. There are few datepickers, to filter custom list data. When user clicks on Export To Excel ( which is asp:Button ) I need to filter data based on datepickers value, and ...
1
vote
1answer
163 views

Excel Services Using SQL Server 2008R2 Refresh

I have an excel file set up to pull data from SQL Server 2008R2. I can view it and refresh it fine locally in Excel 2010. I upload it to SharePoint 2010 and can view the data in the spreadsheet in ...
0
votes
1answer
107 views

What is the best option you would use to show dashboard data within an Excel file on SharePoint?

What is the best option you would use to show dashboard data within an Excel file on SharePoint? A. SharePoint and MS Office Integration. B. SQL Reports integrated with SharePoint. C. ...
0
votes
3answers
6k views

Export list with attachments

We have a legacy Sharepoint Services 2.0 server where users have been maintaining a few custom lists. There are items in these lists that have attachments (Word, Excel, PDF type documents). Over the ...
0
votes
1answer
1k views

Can SharePoint 2010 Monitor Class Attendance and Activities?

The organisation I represent is a coaching company, with a number of coaches spread across the globe. One of the spreadsheets they use most frequently is a tracking sheet for all the people they ...
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 ...
1
vote
2answers
170 views

SP Alert email cuts off Excel table in Office 2010 but not Office 2003

I have an alert set up for a discussion board. We have been using Office 03 just fine, email comes in, the body is shown fully, everything is great. However, when we use Office 2010, not sure if its ...
1
vote
1answer
759 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
0answers
131 views

Excel -> SP List with correct column types?

Are there solutions available for importing an Excel to SharePoint with SharePoint column types? Or has someone tried this with the help of OpenXml (with a custom import web part with default values, ...