Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.
5
votes
4answers
6k views
How to migrate a 2007 sharepoint list to 2010?
We have a list in sharepoint 2007 that we need to move to another site which is based on sharepoint 2010.
what's the best and fastest method?
thanks in advance
4
votes
1answer
474 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?
4
votes
1answer
333 views
Excel Services - when/where image of chart created?
When using Excel services (REST or the webservice) a chart is displayed as an image. Where/when is this image actually created?
I'm asking this, because I was wondering if I can change something in ...
4
votes
1answer
1k views
Filtered SharePoint List for Export to Excel
I have an Issues List is SharePoint that contains over 75 different categories. I would like the ability so that when I use the filter on the column title and select a particular category, that then ...
3
votes
3answers
10k views
possible ways to import an excel spreadsheet to a sharepoint 2010 list?
I am running SharePoint Server 2010 and I have an excel spreadsheet of about 3000 rows / 30 columns, which I would like to import to a SharePoint list.
I've seen on codeplex a free tool for MOSS/wss ...
3
votes
2answers
4k 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?
3
votes
3answers
9k views
Update List from Excel using VBA
I'm in the enviable position of having to support a client who wants to maintain and manipulate a complicated business spreadsheet in Excel, and then push a selection of that data to a list in ...
3
votes
2answers
131 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 ...
3
votes
1answer
2k views
Documents library wants to open Excel file in XLViewer
We've added some Word and Excel documents, as well as PDFs to the default Documents library in a SharePoint 2010 publishing site. However, SharePoint wants to open the Excel files in the built-in ...
3
votes
1answer
395 views
Why does using Actions > Edit in Datasheet result in <div> … </div> HTML formatting in the multiple row text area?
I have a SharePoint List with a column of type 'Multiple lines of Text'. Then I copy a Excel spreadsheet content into the List using Actions > Edit in Datasheet. Later, when I use a HTML text-area to ...
3
votes
1answer
192 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 ...
3
votes
1answer
8k views
Documents open read-only when user should have write access
Scenario:
We have an internal application that ties Excel spreadsheets stored in a SharePoint doc lib with specific Opportunities in CRM. The user clicks on a button in the Opportunity and a Web ...
2
votes
3answers
4k views
create button that export custom list to excel file
I'm using sharepoint 2007, custom list.
from the datasheet view I can export the list into excel/access file.
is it possible to create a button that proposes to export the list to excel.
(in order to ...
2
votes
4answers
11k views
Unable to open office files in Office client
While trying to open an excel document stored in "Shared Documents" library, the excel application opens up with a login prompt, to which I passed the login credentials of the site. After which the ...
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 ...
2
votes
2answers
6k views
How can I share an excel document with my team to edit?
I would like to know if something is possible and where to start.
Each day, my boss sends out a spreadsheet listing our data entry errors for the previous day. All five of us download the sheet, make ...
2
votes
2answers
764 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 ...
2
votes
2answers
1k views
Error - while exporting a Sharepoint List (Export to Excel)
Colleague of mine is facing the below issue while trying to export the SharePoint List which has more than 10 000 items. However I was able to export the complete List without any issues.
Note:
He is ...
2
votes
3answers
11k views
Disable Excel Web Access?
Is there a way to disable Excel Web Access (_layouts/xlviewer.aspx) completely on a Site Collection? (SP2010 Enterprise)
I have enabled the "Open in Client Applications" feature and it works fine in ...
2
votes
1answer
97 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.
2
votes
2answers
733 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
1answer
40 views
Analytics on contents of spreadsheets in a MOSS library?
I have a requirement from a business user that I don't know how to address. The question is this:
Can I count the number of times a specific value appears inside the spreadsheets stored in a ...
2
votes
1answer
42 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 ...
2
votes
1answer
79 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 ...
2
votes
1answer
923 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 ...
2
votes
1answer
790 views
Update existing list in Sharepoint 2010 with Excel or Access 2007?
I'm looking for ways to update an existing list in SharePoint by using either Excel 2007 or Access 2007.
I have seen plenty of ways to create a new list, but nothing about updating existing lists.
...
2
votes
1answer
126 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
0answers
193 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 ...
2
votes
1answer
563 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
1k views
Can I import data from an Excel .iqy file to a sharepoint list?
Can I import an .iqy file into SharePoint 2010 list? Help, please.
1
vote
6answers
7k 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 ...
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 ...
1
vote
3answers
1k 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
3answers
1k views
Excel import to SharePoint
I'd like to be able to import a spreadsheet from Excel into SharePoint and be able to select a list template I've already built. Is this possible? I need to be able to do this so the proper ...
1
vote
2answers
701 views
Interacting with Excel spreadsheet from Sharepoint 2010
I'm wondering is it posible to create or modify Excel spreadsheets that are on SharePoint 2010 programaticaly and how to do it?
1
vote
3answers
5k views
Does SharePoint support Excel spreadsheets linked to each other?
Is it possible with Office 2007 + SharePoint 2007 to have a spreadsheet uploaded to a SharePoint document library having dependencies/links to other spreadsheets also stored in SharePoint? Thanks...
1
vote
1answer
497 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.
1
vote
1answer
909 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 ...
1
vote
1answer
454 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
2answers
8k views
Import Sharepoint List into Excel Using VBA Only
In Excel 2007, I have a VBA script that consolidates various data sources into a single Excel file for monthly archiving and reporting purposes.
How can I import data directly from a Sharepoint ...
1
vote
2answers
149 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
2answers
111 views
query a sharepoint 2010 list from excel vba to retrieve a specific record
I have created a SharePoint 2010 list with 2 relevant columns:
- Identification Key
- Version Number
I want to be able to query this SharePoint list from Excel VBA - passing the Identification Key to ...
1
vote
2answers
661 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 ...
1
vote
2answers
175 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 ...
1
vote
1answer
100 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 ...
1
vote
1answer
794 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 ...
1
vote
1answer
493 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. ...
1
vote
1answer
297 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 ...
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 ...
1
vote
1answer
220 views
Office Web Apps Word - Configure trusted locations
It is possible to configure the trusted file locations for the Word Web App on SharePoint 2010?
I only can find the settings to configure the supported file formats at the Word-Service Application
...
