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

learn more… | top users | synonyms

5
votes
1answer
4k 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 ...
0
votes
2answers
1k 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
277 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
872 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
2k 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 ...
1
vote
1answer
706 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
1
vote
1answer
596 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
98 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
301 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
894 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 ...
1
vote
1answer
655 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 ...
1
vote
1answer
3k 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 ...
2
votes
3answers
2k 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 ...
0
votes
1answer
534 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
1answer
2k 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 ...
0
votes
0answers
237 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
3k 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
506 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 ...
0
votes
1answer
875 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
0answers
271 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
1k 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?
0
votes
1answer
601 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 ...
1
vote
3answers
8k 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
947 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?
1
vote
2answers
2k 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
4answers
765 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 ...