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

learn more… | top users | synonyms

0
votes
0answers
992 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 ...
1
vote
1answer
170 views

Excel Services Using SQL Server 2008R2 Refresh

I have an excel file set up to pull data from SQL Server 2008R2. I can view it and refresh it fine locally in Excel 2010. I upload it to SharePoint 2010 and can view the data in the spreadsheet in ...
0
votes
1answer
114 views

What is the best option you would use to show dashboard data within an Excel file on SharePoint?

What is the best option you would use to show dashboard data within an Excel file on SharePoint? A. SharePoint and MS Office Integration. B. SQL Reports integrated with SharePoint. C. ...
0
votes
3answers
8k views

Export list with attachments

We have a legacy Sharepoint Services 2.0 server where users have been maintaining a few custom lists. There are items in these lists that have attachments (Word, Excel, PDF type documents). Over the ...
0
votes
1answer
2k views

Can SharePoint 2010 Monitor Class Attendance and Activities?

The organisation I represent is a coaching company, with a number of coaches spread across the globe. One of the spreadsheets they use most frequently is a tracking sheet for all the people they ...
1
vote
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
174 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
1answer
961 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
0answers
133 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
474 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.
2
votes
1answer
1k 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. ...
0
votes
0answers
254 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 ...
3
votes
1answer
444 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 ...
2
votes
1answer
44 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 ...
4
votes
1answer
3k 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
216 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
778 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
608 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
550 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
93 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
286 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
850 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
612 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
514 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
229 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
465 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
761 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
266 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
973 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
583 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
7k 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
871 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
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
4answers
759 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 ...