Microsoft Excel is a commercial spreadsheet application, which can be integrated with SharePoint.

learn more… | top users | synonyms

0
votes
2answers
909 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 ...
1
vote
0answers
166 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 ...
1
vote
1answer
6k 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
0answers
628 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
2answers
1k views

How to Export sharepoint 2010 SPGridView data to excel

How to Export sharepoint 2010 SPGridView data to excel. My data with tree strutured is avilable in spgridview. Note: if any of the column value contains multiple value then i need to convert into ...
0
votes
1answer
468 views

import excel as an document library

Is there a way to import excel as an document library just like custom list > import spreadsheet? Thanks
2
votes
1answer
984 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
3answers
5k 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 ...
0
votes
1answer
88 views

Can published excel be modified from with in sharepoint?

I have an excel table that i wish to publish which displays our users call stats on a certain date. Change the date cell and the table refreshes through a series of IF statements from the data tab. ...
0
votes
2answers
2k views

How to read excel file contents from the database?

I have a problem that involves reading contents of an Excel file after the excel file has been added to a document library in SharePoint 2010. Reading the file contents was easy on client machine with ...
1
vote
1answer
258 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 ...
1
vote
1answer
719 views

How to add Excel web access web part in WSS 3.0

I'm new is SharePoint and struggling with adding web part. I'm using WSS 3.0. I want to add Excel Web Access Web Part, so I go to site Actions -> Web Part Gallery and try to upload .wdp file which ...
2
votes
6answers
10k 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 ...
2
votes
2answers
847 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 ...
6
votes
5answers
18k 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 ...
1
vote
1answer
499 views

Excel Web Access & VSTO

I created an Excel workbook in Visual Studio 2010 using VSTO, and it fills a table with data retrieved from a WCF service. The service was added to the project using the standard "Add Service ...
0
votes
1answer
444 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 ...
1
vote
3answers
2k 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 ...
0
votes
0answers
217 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
vote
1answer
2k 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.
4
votes
1answer
401 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 ...
3
votes
3answers
13k 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 ...
1
vote
2answers
167 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
0answers
257 views

Integer field/column lost at export to Excel [closed]

I have created a list in SharePoint 2010 via a published InfoPath 2010 form. The fields/columns of the list are of different types like Single line of text, Integer, Date and Time, Yes/No, Number etc. ...
1
vote
2answers
221 views

Ability to migrate linked Excel spreadsheets to MOSS

Hi our finance team have multiple links to other spreadsheets within the current file server. We wish to migrate these to Sharepoint to offer them a solution via Extranet. Is this possible? There ...
0
votes
2answers
207 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 ...
3
votes
1answer
218 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 ...
1
vote
4answers
8k views

Import from Excel to an existing list

I'm trying to import data from excel into an existing list. I can paste one line at a time by opening the excel doc and the sharepoint list in datasheet view, but that's not very efficient. Any ...
0
votes
2answers
3k views

Sharepoint seeking authentication when opening Word / Excel files from website

The company I work for is using SharePoint as a CMS for it's public facing website. I recently enabled FBA (Forms Based Authentication) for the site in order to provide some user specific ...
2
votes
3answers
15k 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 ...
4
votes
2answers
2k 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
4answers
14k 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 ...
2
votes
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
893 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
1answer
547 views

How to bulk update records in a SharePoint List with a lookup column (with type Person)

In SharePoint 2007 I have a List containing two columns: "Title" of type single line of text "Email" of type Person or Group Because I have to update a lot of records, I use export to Excel to ...
6
votes
4answers
9k 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
1
vote
1answer
1k views

sharepoint 2010 : Download Data as Excel reports

We are working on a share point 2010 application where there is a requirements of complex reporting. As per requirement there will be a Link List which will have couple of links. On clicking these ...
1
vote
1answer
2k views

Excel new document template opens in Notepad

I have a document library with a custom document template. The template is an .XLTX file that I created using Excel 2010. It is associated to the library via a custom content type. The template ...
1
vote
3answers
1k views

Can an Excel file be used as an external content type?

or an external datasource? Can that be set up in SP Designer 2010
0
votes
1answer
557 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
2answers
2k views

'Export to Spreadsheet' error

I'm working with WSS 3.0 and have access to a number of sites within SharePoint. I and a number of other users have run into an issue that is happening when we try export a list using the "Export to ...
1
vote
2answers
1k views

Can I export a SharePoint 2007 list to an Excel file subdivided into separate worksheets?

We have a SharePoint 2007 deployment which will have a substantially large document library. My client wants the ability to export this library to an Excel spreadsheet, but specifically wants the ...
0
votes
1answer
657 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. ...
1
vote
3answers
6k 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
2answers
816 views

How do I make a easy print out (overview like excel) in Sharepoint?

If we use action items for projects/meetings and we want to make an easy print overview, this seems to be impossible. Any ideas or suggestions?
3
votes
1answer
12k 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 ...
0
votes
4answers
747 views

Access denied on edit in excel

Has anyone seen an error occur when a user performs the edit in excel action and the user gets an authentication prompt which they can't get past with their correct credentials and then a similar ...