Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.
2
votes
1answer
120 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 ...
2
votes
1answer
538 views
Export custom list to excel
I'm using SharePoint 2007. I have created custom-list.
The list contains one column from "Person and group" type, show field: E-mail.
I fill in data in the list column and export this list to excel ...
1
vote
1answer
40 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 ...
1
vote
1answer
43 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 ...
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 ...
1
vote
1answer
3k views
Making a link from SharePoint site to Excel file on Shared Drive
Even though solution to this might not be SharePoint related, but thought to ask here anyway in case someone has some thoughts.
I'd like to make it possible to open certain Excel macro-enabled ...
1
vote
1answer
520 views
Export to Excel for sharepoint 2010
Export to excel was previously not working for clients that were using Office 2007 because we we are using claims based authentication. A few days ago a few clients noticed that the export to excel ...
1
vote
1answer
2k views
Adding document version number on Excel Spreadsheet as label for printing purpose
I have a situation where I need to have version number on each document in version controlled document library.
Having version number on printed sheet would help to see the validity of document.
I ...
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
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
1answer
456 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
0answers
185 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
0answers
13 views
Enable Publishing Options button without SharePoint Designer
We use MS Office 2010 Standard, and some users will be publishing spreadsheets from Excel to SharePoint (2010). We have discovered, however, that the Publishing Options button only appears in the Send ...
1
vote
0answers
67 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 ...
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?
1
vote
0answers
48 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.
1
vote
0answers
62 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
32 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 ...
1
vote
0answers
175 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
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 ...
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, ...
1
vote
0answers
220 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
0answers
118 views
Want to link to specific sheet in Excel workbook which is stored in SP10 doc library, but usual method not working
I have an excel workbook stored in Sharepoint 2010 document library. It contains several named sheets. I wwant to link to the workbook from a Wiki or List but I want specific sheets to be visible ...
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
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
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
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
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
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
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
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
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
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
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
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
0answers
204 views
Error message :File extension changes to .aspx on opening any excel or word file in a sharepoint document library
I have a document library in Sharepoint 2007 which consists of few word and excel files.
Whenever i try to open a file, it shows the message " the file [filename.aspx] you are trying to open is in a ...
0
votes
0answers
472 views
Import Excel as List Fails
I have an Excel Spreadsheet that I want to import into SharePoint 2010 as a list but upon doing so I receive the following errors. As a work around I have saved the spreadsheet as csv and then ...
0
votes
0answers
194 views
Import from Excel Spreadsheet works in IE6 not IE8
I'm having an issue in SharePoint 2007 in IE 8 where, when creating a new List using Excel Spreadsheet Import, I get redirected to a 403 error. This feature works in IE 6 but not IE 8. Can anyone ...
-1
votes
0answers
79 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 ...
