Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.
0
votes
0answers
102 views
Any way to speed up Excel Web Viewer Web Part?
Is there any way to speed up the loading time of a spreadsheet in SharePoint 2007? I noticed that especially in IE it can take up to 10 seconds or longer but often in Chrome/Firefox it loads within 1 ...
0
votes
0answers
164 views
excel worksheet is blank when opened in sharepoint 2010
I'm running into an issue where users are trying to open an Excel 2010 worksheet by clicking a link in our Sharepoint 2010 document library. When the user clicks the link, it opens the worksheet in ...
1
vote
1answer
303 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 ...
0
votes
1answer
82 views
Excel Calculation Services - Excel Web Apps
We're trying to co-author excel workbooks but only have Standard CAL/Sharepoint 2010 Standard Server license. Its my research so far that to have co-authoring for Excel, we would need to use Excel ...
0
votes
0answers
122 views
PowerPivot with MySQL connector
I have a powerpivot document using a MySQL connector and when added to SharePoint it doesn't seem to think it has a dataconnection.
Is there anyway to get this type of powerpivot document to work ...
0
votes
1answer
157 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
2answers
112 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 ...
0
votes
1answer
525 views
Excel web part from list - Autorefresh
I am using SharePoint 2010.
I currently have a list that gets updated many times throughout the day.
I currently have an Excel Web Part with graphs and summary tables on the first tab, and its data ...
0
votes
0answers
362 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
0answers
140 views
Show “Path” field in list view export?
I have a report from a user that claims was generated by clicking the "Export to spreadsheet" button within a document library. This report contains not only All the files and folders from a level 3 ...
0
votes
2answers
53 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
782 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
2answers
2k views
Export to excel - large lists
I am having when Exporting large lists to excel (over 14K records). It displays “Running security Scan” at the bottom of the screen and then gives “An unexpected error has occurred. Changes to your ...
0
votes
0answers
55 views
Is it possible to sort by month name in PowerView?
Is it and if how possible to sort by month name without having to add a number in front in Powerview? I would like to change these month id's to month literals so 1 > JAN:
Screenshot 1
0
votes
1answer
389 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
863 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
305 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
74 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
186 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 ...
2
votes
2answers
690 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
2k 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
468 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
2answers
579 views
Export SharePoint Search Results and List View to Excel
Can we export SharePoint Search Result to Excel? Note that our client is using SharePoint Foundation 2010.
I have searched the web and found a free tool that does this but unfortunately it works only ...
0
votes
1answer
518 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 ...
0
votes
0answers
66 views
Issues with saving Excel Document on close
I'm having some rather weird issues with one folder in my document library which contains about 4 Excel documents. Here is the sequence on what the users do to edit the files:
Click document > edit
...
0
votes
1answer
3k 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 ...
3
votes
2answers
127 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
232 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 ...
1
vote
0answers
63 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 ...
0
votes
0answers
203 views
Sharepoint List in access as Excel connection?
I have a sharepoint list that I open In MS Access. When I try to create a connection in a MS Excel sheet to that access list I keep getting the error "This datasource contains no visible tables". How ...
1
vote
1answer
196 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
1answer
371 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
2answers
2k views
Unable to Refresh the Excel Connection in Excel Webaccess Webpart
I am using an excel workbook with pivot in it. I am using the Excess webpart to display it. As I click on the Refresh all data connection.
It throws an error.The scree shot is attached.
I have ...
0
votes
2answers
947 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 ...
1
vote
1answer
289 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
1answer
128 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
564 views
Excel file opening in XLViewer for some users
We have a corporate internal portal with lot of subsite and document library for various department/BU.
When a user tries to open a excel file from a document library it opens in Excel client from ...
0
votes
2answers
145 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
1answer
130 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 ...
1
vote
6answers
6k views
Update Sharepoint list using excel
I have a SharePoint that has list and I need to be able to update this list with new values from an Excel sheet (using VBA).
This can be done from Access not a problem however I need it to be Excel ...
0
votes
1answer
86 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
3k 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 ...
2
votes
1answer
874 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
1answer
136 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 ...
1
vote
1answer
163 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
0answers
503 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 ...
0
votes
2answers
851 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 ...
0
votes
2answers
1k 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
1answer
420 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
106 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, ...
