Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.
0
votes
0answers
11 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
11 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 ...
1
vote
1answer
30 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
29 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 ...
1
vote
1answer
26 views
saving an excel file: You do not have the correct permissions. Contact the server administrator
a user is attempting to open an excel file from a SP 2010 library, make edits, and save it back. when clicking save, he gets this error message in a popup window: You do not have the correct ...
0
votes
0answers
35 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 ...
-1
votes
0answers
63 views
How to Check if user is connected to Sharepoint using VBA
I have a Microsoft Access 2010 database published to Sharepoint 2010. I am able to use an ADO connection to connect to the database from Excel. The Excel file is not published to Sharepoint, just ...
0
votes
1answer
40 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
14 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
23 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
1answer
22 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 ...
2
votes
2answers
167 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 ...
0
votes
2answers
73 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
164 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 ...
1
vote
2answers
326 views
SharePoint 2010 error when importing excel spreadsheet to sharepoint list
I get the following error when trying to import an excel spreadsheet into a SharePoint list.
"The specified file is not a valid spreadsheet or contains no data to import"
I have added this site to ...
0
votes
1answer
365 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) ...
2
votes
1answer
38 views
Creating lists within lists, or tables within lists, or…?
I have just started working with a company on a variety of different IT issues, mostly Sharepoint 2010. They are going to contract a Sharepoint developer to help with a problem they have been having ...
1
vote
2answers
127 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 ...
0
votes
0answers
44 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
30 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 ...
1
vote
0answers
63 views
Use an Access Web Database as a data source for Excel?
I have an Access 2010 Web Database published to SharePoint as described here:
http://office.microsoft.com/en-us/access-help/build-an-access-database-to-share-on-the-web-HA010356866.aspx
If my Access ...
0
votes
0answers
73 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
129 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?
1
vote
1answer
325 views
Unable to refresh data for a data connection in the workbook.
I am trying to use an Excel Web Part that connects to a list in Sharepoint 2010.
On my local drive the spreadsheet updates when I open it and all is well but when I uploaded to sharepoint the data ...
1
vote
1answer
86 views
If a user can't read Excel file, can they still view Chart Web Part created from it?
Title sums it up. I would just try it myself but my test environment is down and I figured I might get a speedier response here than to wait for that to come up.
If users don't have permissions to ...
0
votes
1answer
1k views
Excel links open files as read-only mode. How to change this to edit mode?
Does anyone have any idea why using the link on excel opens the file as read-only mode?
How can I change the behavior to open as Edit mode?
I checked almost all of the Document Library settings, ...
1
vote
1answer
381 views
SharePoint List Export to Excel All Columns!
As you may know SharePoint's default export to excel only exports the columns of that current view to excel. Is there anyway to export all columns, without adding all columns to that current view.
0
votes
1answer
166 views
How to modify an Office (Word, Excel) file in sharepoint programmatically
I need to Open and modify a document that resides on a Sharepoint Document Library.
These changes on the file are done during an event generated by a Document Library, so I must change it by code.
...
1
vote
0answers
18 views
Import excel spreadsheet with photos
I am trying to import an excel spreadsheet with photos, It import without problems, except that it removes the photos.
What am I doing wrong?
0
votes
0answers
73 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
0answers
34 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 ...
2
votes
1answer
91 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
0answers
43 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.
4
votes
1answer
372 views
Run an Excel Macros from SharePoint
I was wondering if it's possible to initiate Excel macros (Excel file is located on a network drive) from SharePoint? Are there any add-in features within SharePoint that can communicate with macros?
0
votes
1answer
695 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 ...
1
vote
0answers
61 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
29 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 ...
2
votes
1answer
71 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
46 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, ...
1
vote
0answers
169 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 ...
0
votes
0answers
131 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 ...
2
votes
1answer
117 views
How to import one single row of data from excel to one list item in a SharePoint 2010 list?
I have a problem where we want users to attach a file to a new item and the SharePoint list will automatically read on row or column of data (maybe 20 cells-worth of data) and populate some additional ...
0
votes
2answers
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 ...
2
votes
0answers
177 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 ...
0
votes
0answers
135 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
95 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
155 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
286 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 ...
