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

learn more… | top users | synonyms

1
vote
0answers
187 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
0answers
263 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. ...
0
votes
2answers
62 views

Upgraded SP Servers and now webpart can't access C drive

We had one WFE server and upgraded to 2 WFE servers with a load balancer. We are using the SharePoint Server Standard edition. Because we are using the Standard edition and do not have access to BI ...
0
votes
2answers
170 views

SharePoint list not accepting copied excel data

Hello I am having an issue with a SharePoint list not accepting copied data from an excel sheet while in datasheet view. The sheet has 130 rows of data I have done this before and made sure the ...
0
votes
3answers
61 views

How to export list items in same order in a list to excel 2010 (console application)?

I require to export list items from a SharePoint list to Excel. The order of items in the Excel sheet should be the same as in the list. Can somebody suggest console application code for this?
0
votes
2answers
231 views

Hard limit to have number of Excel webparts on SharePoint 2010 page?

Is there any hard limit to have number of Excel webparts on the SharePoint 2010 page?
0
votes
1answer
71 views

Linking an Excel document to a List

I have an excel document which is sent daily to me. I have a SharePoint List that is then update daily by me with all the excel documents information (complete overwrite each day). The list is used ...
0
votes
1answer
116 views

Issues in some contents of Excel web access web part in mozila firefox and google chrom

Whenever we create an Excel web page, using Excel web access web part, we got an option "open in excel". That "open in excel" option is not working in google chrome but it is working in Internet ...
0
votes
2answers
2k views

Excel Web Access Not Disabled?

I uploaded a spreadsheet to one of my sharepoint 2007 sites. When I click on the link I get the error "Exxel Web Access An error has occurred. Please contact your system administrator if the problem ...
0
votes
2answers
1k views

Excel file opening in XLViewer for some users

We have a corporate internal portal with lot of subsite and document library for various department/BU. When a user tries to open a excel file from a document library it opens in Excel client from ...
0
votes
2answers
2k views

Open docs from SP2010 in excel/word crashes

I have: SP2010 rented from a company. 1 site collection I have IE 9.0.8 For about a 6 months I have this consistent problem. When I click on a Word doc or Excel doc, I get a choice to edit, I do ...
0
votes
3answers
6k views

Import Excel to SharePoint list -> Auto-synchonize based on Id

Are there tools available for importing an Excel file to a SharePoint list so that the importing data would be synchronized based on specified field(s)? I would mostly be interested in a ...
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 ...
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 ...
0
votes
4answers
752 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 ...
0
votes
1answer
44 views

SharePoint List View - Export to Excel with Formatting and Grouping

I have a SPList View with 2 levels of grouping. First level is Company and the second level is 'Month - Year' which is a calculated field. Below is the view's screen shot: The issue is when a do ...
0
votes
3answers
181 views

Can we create Excel file using c#?

I would like to know if it is a good idea to create an excel file using c# in sharepoint? I've tried to find js libraries but despite ExcelBuilder which seems really complicated to use i can't find ...
0
votes
1answer
38 views

Setting to enforce use of Excel Services rather than Excel Web App

Our site and sub-sites are defaulting to Excel Web App rather than Excel Services. We require Excel Services. I think maybe I hit a setting somewhere at the root which has caused this change. Where ...
0
votes
1answer
77 views

SP13: Overwriting Excel Importing List

This task seems easy, but is turning out to be more complex than I expected. I have a excel spreadsheet that I have imported into a custom list. In order to import the excel spreadsheet by using ...
0
votes
2answers
513 views

Import File from SharePoint and Link this file with SharePoint (File- Excel File)

I am using SharePoint 2013 and Microsoft Office 2007 or above. Scenario: I upload a Excel file to a SharePoint 2013 list. Now, I want to import this Excel file from this SharePoint list back to ...
0
votes
1answer
179 views

How to show version number when using 'Export to Excel' command

my firm is transferring a project to another firm. The new firm wants a list of all of our files. I went into our sharepoint library and selected "Export to Excel" which returned a spreadsheet with ...
0
votes
2answers
275 views

Unable to save excel to SharePoint 2007

I have a user who is having issue saving changes he made to an excel file stored in a document library. He has contribute access to the library. The setting on the library does not require check out ...
0
votes
1answer
31 views

In Excel, OnClick I need to save then add a workbook to a SPT 2010 Standard Edition doc Library? How to do this?

I am not a coder, but I have seen VB scripts that "kind of" does this.. I'm willing to try (nervous smile). I need to add a button in an Excel workbook that will "auto upload" the workbook to a ...
0
votes
2answers
818 views

ECB “Edit in Microsoft Excel” is missing for users

I have bunch of user in a SharePoint group with Special Contribute access (same as contribute permission but No delete). These users are not seeing "Edit in Microsoft Excel" in the ECB menu. If I log ...
0
votes
1answer
232 views

Export all of Sharepoint 2010 data (list, webapp data, etc. )

I need to export all of Sharepoint 2010 data (list, webapp data, etc.) in to a easy to import file. Meaning I have "SiteName" with lists and webapp data, and I need all the information of that site in ...
0
votes
1answer
289 views

Error exporting list to excel - permissions for resource throttling ceiling

What level of permissions have to be assigned to a user account in SharePoint 2010 for them to qualify as an "administrator" and therefore grant them access to the higher ceiling for resource ...
0
votes
1answer
37 views

Open documents in client unusual behavior

I recently modified settings at the list level to force documents to open on the client. After I tested the behavior while logged in as an Admin and it seemed to work fine. Today however an end user ...
0
votes
1answer
925 views

How to modify an Office (Word, Excel) file in sharepoint programmatically

I need to Open and modify a document that resides on a Sharepoint Document Library. These changes on the file are done during an event generated by a Document Library, so I must change it by code. ...
0
votes
3answers
7k views

Cannot open word document and Excel from Sharepoint 2010

I am not able to open any word documents and Excel from my Sharepoint2010 sites. I was able to open them before I re-installed everything from scratch. When I try and open any uploaded Excel document ...
0
votes
1answer
391 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
1answer
211 views

Migrate Excel Docs from Shared Drive to Sharepoint Foundation 2010?

I have a fairly large shared drive with various files that need to be migrated over to SharePoint. I only have full control of my site, which is a subsite within the hierarchy. I feel like if I were ...
0
votes
2answers
1k views

Excel web part from list - Autorefresh

I am using SharePoint 2010. I currently have a list that gets updated many times throughout the day. I currently have an Excel Web Part with graphs and summary tables on the first tab, and its data ...
0
votes
1answer
1k views

Simultaneous working with Excel in SP2010

Is it possible to work with multiple users simultaneous on the same excel document in SP2010? If possible without the excel web app. Extra... Is it possible to work with different versions then? ...
0
votes
1answer
758 views

Tracking Changes to Individual Cell in Excel Spreadsheet on SharePoint?

I've gotten a weird request today, someone I work with asked if there is any way to track changes to a specific cell in an Excel Spreadsheet. The spreadsheet is hosted on SharePoint and they want to ...
0
votes
1answer
1k views

Getting rid of the session timeout in Excel Web Access?

I understand there is a 30 second short session timeout (if no interaction is detected) to a 5 minute extended sessiopn timeout. The userss would like their reports up all day, just refreshing every ...
0
votes
1answer
5k views

Cannot open file using Edit options

We recently had a few users in our environment upgrade to Excel 2010 and all these users are now experiencing the same problem where they cannot edit files by clicking them in the library or using the ...
0
votes
1answer
875 views

How to manage a dynamically updated Excel file in SharePoint

When we have a client that requests a call back, we fill out a web form that automatically populates an excel spreadsheet on a shared drive. Reps will then access the spreadsheet and take appropriate ...
0
votes
1answer
107 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
7k 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
193 views

SharePoint 2007 and Large Excel files

I have a user that has create an Excel file, the file has 16 tabs on it, and 14 of the tabs are graphs and the last two 15 & 16 tabs are pivot table that control the graphs. Tab 15 pivot tables ...
0
votes
1answer
1k 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 ...
0
votes
2answers
1k views

How to customize SharePoint Chart web part

I want to customize SharePoint chart web part programmatically to display charts from the excel sheet having different charts on different sheets of the excel. How can I customize chart web part so ...
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 ...
0
votes
1answer
488 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 ...
0
votes
2answers
236 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 ...
0
votes
1answer
570 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
1answer
702 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. ...
0
votes
1answer
17 views

Quick edit List URL field

I need to use the quick edit on a Link List (I am copying data from an Excel file). I am having trouble with the URL field, I can easly insert the URL but I don not know how to insert the URL name. ...
0
votes
1answer
26 views

How to get excel file from sharepoint library and write to it programmatically

we would like to read an Excel template stored in a SharePoint 2010 library create a new Excel file from it fill the new Excel file with data programmatically we tried already Excel Services but ...
0
votes
1answer
15 views

How can I know what was modified in an Excel file hosted on a SharePoint site?

Currently, I have an alert set up so that if someone modifies an Excel file I receive an e-mail. It works fine. However, I can I tell what was modified when I go back to check on the file?