Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.
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
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 ...
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 ...
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 ...
0
votes
1answer
397 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 ...
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
609 views
Is it possible to link a chart in a Word document with an Excel Spreadsheet in SP 2010?
I have a word document which contains some charts based on data in an Excel spreadsheet. I update the word document frequently (it is as status report) by editing some of the supporting data in the ...
0
votes
2answers
4k 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 ...
0
votes
1answer
363 views
Excel 2003 compatibility with SharePoint standard edition 2007
I'm hoping someone can provide me with some good information/links with regards to the compatability/limitation of sharepoint standard edition and Excel 2003.
I've searched all around google and ...
0
votes
2answers
148 views
How to prevent users from getting at the source files for Excel Web Services
I have a request to put a large Excel dataset on a MOSS 2007 sharepoint page.
The XLSX is about 13 MB in values alone - about 50,000 rows. It's updated weekly, usually in batch form (i.e. some ...
0
votes
1answer
503 views
Is it possible to set up an ODBC connected Excel spreadsheet on SharePoint 2007 with a Standard license?
I know that many database connections are possible with the Enterprise version of SharePoint Server 2007. Is it possible to make a custom solution to set up a connection? If it depends on the type ...
0
votes
1answer
588 views
Export an agenda in a meeting workspace
I have a meeting workspace with a recurring meeting. (WSS 3.0 hosted by Network Solutions)
When I export the agenda to Excel I get the previous agendas as well as the one for the selected meeting.
...
0
votes
0answers
6 views
How to link Excel to Acces when the files are saved on sharepoint, then refresh in Excel service
We have files in excel that are saved on sharepoint. We want to pull this into access, but when trying to link to them from access, we get a an error that they must be XML files. How can i link ...
0
votes
1answer
16 views
Displaying Version # In Document
I am looking for a way to display the SPItem version number from within an Excel document. We are authoring an Excel Template in a version controlled document library. I want the Excel document to ...
0
votes
0answers
12 views
Publishing Named Ranges Programatically
I have a document library containing excel files with named ranges. I created some excel web parts programmtically and linked these excel web parts to my excel files in my document library.
My ...
0
votes
0answers
13 views
Data truncated when pasting worksheet into multiline field
I'm trying to paste the contents of an Excel sheet into a list in Datasheet view. This list has several multiline columns, and the Excel data items i'm trying to paste in are quite large--in some ...
0
votes
0answers
52 views
SharePoint 2010 List Excel Export Error
I have some problems about exporting a SharePoint List to excel. I'm getting "Excel cannot connect to the SharePoint list" error while exporting it to excel. There wasn't any error in the same list ...
0
votes
1answer
41 views
Documents Not Prompting to Check Out and Not Saving
I am getting strange behavior on some of my users machines when they attempt to edit an Excel workbook from SharePoint. When the user clicks on the document link it opens the workbook in Excel and ...
0
votes
0answers
18 views
Autoupdate Excel Links
I'm running into issues including formulas/links into an Excel file stored on SharePoint. As soon as I download the Excel file locally to my desktop SharePoint adjusts the formulas to use the server ...
0
votes
0answers
28 views
How to automatically generate the URL for the “URL Access” of SSRS Reports in a Report Library?
This is my setup:
I've a few reports developed using Business Intelligence Development Studio & deployed on Reporting Services in SharePoint Integrated mode.
The RDL files are deployed to a ...
0
votes
2answers
109 views
Is there a free sharepoint hosting site where I can try out Access 2013 asset tracking template?
Is there a free sharepoint hosting site where I can try out Access 2013 asset tracking template? I just want to see how it works.
0
votes
2answers
213 views
Fail to export custom SPList to Excel
Im trying to export a SharePoint-List(created from a custom Listdefinition) to Excel by using the "Export to Excel"-button on the ribbon. It works when im trying with other default SharePoint-lists ...
0
votes
2answers
25 views
French excel numbers being changed to english when uploaded to SharePoint, how to fix?
I have a site where I've uploaded an excel document that was translated by one of the companies we use and once I uploaded it to my SharePoint site but the column that contained numbers changed to ...
0
votes
1answer
458 views
Why are .xlsm files opened as read-only when .xlsx are not?
I have a number of Excel files attached to SharePoint 2010 records. Those with .xlsx extensions open quite happily and can be edited and saved back, but those with .xlsm (i.e. with embedded macros) ...
0
votes
0answers
46 views
Is there a way to prevent Excel Web Access from loading it's workbook on page load?
I have a sharepoint page that I am working with and it contains an Excel Web Access Web Part. That EWA Web Part is used to display and filter a large report that connects to an OLAP cube, and takes ...
0
votes
0answers
34 views
Can I export list instances as .wsp package?
We are having an issue where in our 2010 solution the list instances are populated by an excel spreadsheet import using Microsoft.Office.Interop.Excel. Unfortunately this cannot be done in the UAT ...
0
votes
0answers
76 views
How to import an excel spreadsheet into SharePoint Assets web database?
I would like to utilize the SharePoint Assets Web Database to track approximately 700 computers we have at our site. I currently have the information in an Excel 2007 spreadsheet, and would like to ...
0
votes
1answer
132 views
How to convert Sharepoint 2010 Chart web part to Excel?
I want to convert chart webpart's chart to excel format
how it is possible?
0
votes
0answers
36 views
Sharepoint link issue
I am having a weird issue. I uploaded an excel document to sharepoint, and when I click the link it does not do anything, however if I right click open in new tab it opens. ** This is an excel ...
0
votes
0answers
78 views
Bind Sharepoint List Fields with excel columns
Hi i have to bind Excel columns to Sharepoint list Columns and my excel contains not just a simple Grid. It is a template which looks like this :
is it possible to bind this straight forward like ...
0
votes
1answer
734 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
1answer
48 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 ...
0
votes
0answers
102 views
Doc Library Template (Excel) cannot use macros?
So I uploaded an Excel template file to a document library so each time a new document ids created using 'Add Document' the template will be what the users fill in.
Now this template has two macros, ...
0
votes
0answers
132 views
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine [closed]
I am using this code to read excel data into sql.But i got error like this The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine .Plz give good solution for me.
String ...
0
votes
3answers
2k views
Cannot open word document and Excel from Sharepoint 2010
I am not able to open any word documents and Excel from my Sharepoint2010 sites. I was able to open them before I re-installed everything from scratch.
When I try and open any uploaded Excel document ...
0
votes
0answers
137 views
SharePoint 2007 List export to Excel 2007
Good Morning,
I exported the contents of a SharePoint list to an Excel worksheet; however, I noticed the colors and formatting that have been applied to the data. This was done automatically as a ...
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 ...
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
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
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
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
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 ...
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
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 ...
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
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 ...
