.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

AppEvents_WorkbookOpenEventHandler not firing when workbook is opened from sharepoint

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :SharePoint

Why does the AppEvents_WorkbookOpenEventHandler that I've specified in my Excel AddIn not fire when the workbook is opened from Sharepoint; however, fires just fine when opened from the file share version of the same site?

View Complete Post

More Related Resource Links

Trigger a macro anytime a site or web is opened in SharePoint Designer

Within SharePoint Designer (not interfacing with SharePoint services), I would like to have a macro automatically run anytime a web is opened. I assume I need to use the OnWebOpen VBA event but I'm not sure how to write this into a module. Is there any chance someone could assist me with what this sub routine should look like? Thank you! Greg

Sharepoint Event Handler not firing

I have written an event handler for an ItemAdded eventfor a document library. I am trying to read an excel file being uploaded and extract a value from it which I write to a list column for the item. I have this working properly on my development machine which is a Windows Server 2003 machine.However, on a production Windows Server 2008 machine, the event handler never fires. I am doing a simple write to a log file to test and see if it runs at all even if the Excel parsing does not work but I get no indication that it ran. The event handler is being registered with a feature that I am deploying. I have verified that the event handler is registered to the library by using the u2u Event Handler Explorer tool.Is there any way I can determine if my event handlers are even executing? How can I debug this?

This Page has been modified since you opened it on Sharepoint 2010

When I use Server.Transfer("page2.aspx") the page2.aspx get's succesfully loaded. But when you you use Server.Transfer("page1.aspx") to get back from that page2.aspx to the page1.aspx. I got the following error: This Page has been modified since you opened it. You must open the page again... The above scenario is working perfectly on MOSS2007. Has anybody got an idea why this is not working on Sharepoint 2010 server? Thx Kris Kris Buntinx

Excel Services 2010 Error - "The workbook cannot be opened."

I enabled Excel Services and added a Excel Web Access viewer to my page. It's just a simple spreadsheet (which incidentally works fine on my standalone development server) that displays the error "The workbook cannot be opened." when the page loads. The trusted file locations are set up appropriately. We are using Kerberos authentication. My event viewer showed this "Critical" event (ID: 3760): SQL Database 'Prod_WSS_Content' on SQL Server instance 'servername' not found. Additional error information from SQL Server is included below. Cannot open database "Prod_WSS_Content" requested by the login. The login failed. Login failed for user 'domain\user'. In other words, the service account that ECS was running under did not have permission to the content database. So I granted the user read permission on the database. Then I got the same error and this "Error" level event in the event viewer (ID: 5617): There is a compatibility range mismatch between the Web server and database "Prod_WSS_Content", and connections to the data have been blocked to due to this incompatibility. This can happen when a content database has not been upgraded to be within the compatibility range of the Web server, or if the database has been upgraded to a higher level than the web server. The Web server and the database must be upgraded to

The document could not be opened for editing. A Microsoft SharePoint Foundation compatible applicati


Hi All,

I have a document library which contains doc files. Microsoft office is not installed over the SharePoint server. When I am opening the document file from any Windows 7 or windows server 2003 machine it is giving me following error. (The client machines have microsoft office installed.)

"The document could not be opened for editing. A Microsoft SharePoint Foundation compatible application could not be found to edit the document."

Now when I open the same document from XP machine every thing works fine.

It is nothing to do with Firefox or IE version I have checked with all and the results are same for all browsers.

I am started loosing interest in SharePoint for its unpredictable behavior. Developing a thing in SharePoint is 10% work and 90% debugging.

I hope I will get some result or atleast the reason for behavior.


Mahitosh Kumar

Cannot Publish Excel 2007 workbook to Report library on MOSS 2007 Sharepoint



I use Windows 7, trying to Publish an excel workbook to MOSS 2007 Report Library. When I type the location in the "Save As.." dialogue, It disappear & file is not saved.

If I do the same from Windows XP OS with Office 2007, I get the Report Library content (the sp folderrs), so I can navigate & file is published succesfuly

Please help :-)


On excel sheet upload read the workbook and populate data to sharepoint list


Requirement in my current project:
In a document library when I upload an excel sheet, a specific workbook has to be read and the contents have to be uploaded to a sharepoint custom list.
The approach followed was create an event receiver and register as a feature. Following is the code for event receiver.

public override void ItemAdded(SPItemEventProperties properties)
            var list = getSPList("{150301BF-D0BD-452C-90D7-2D6CD082A247}");          
            SPListItem doc = properties.ListItem;
            doc["Msg"] = "items deleted from req list";
            string excelname=doc.File.Name;

Using Sharepoint to accept User Workbook Input


I'm looking for guidance here. I believe it makes sense for me to set up a sharepoint site to accept users' workbooks to be used as input to my (currently Access) database. I have a set of users who periodically submit a workbook to my team that contains updates to third party pricing in my application. I want to standardize the process and automate it. Basically, my app opens the workbook, validates its format and content, then proceeds to post the updates to a (currently Access 2007) table using a fairly complex program (lots of data validation, business rules, etc.), puts notes about each row's status (system updated successfully, duplicate entry, invalid numbers, etc.) directly back into the workbook. The user saves the workbook with a slightly revised name, then sends it back to the submitter.

It seem to me I should be able to create a Sharepoint-centric way to do this. A user adds a new workbook to a SP library. SP sees the new entry, somehow processes it, then posts the revised workbook back to the site and notifies all the appropriate parties about the results of the run.

What's the strategy? Can I avoid user intervention? Do I need to rewrite the programs in C# or VB.NET and trigger them from some Sharepoint process? Help me with some ideas where to go. Here's my thought (though I am not sure how to implement....)

  1. User posts a wor

Unable to save Excel files opened from SharePoint

Hi all!

From time to time users have problem saving excel files that they have opened from a SharePoint document library.

Error message:

"Document could not be saved"

It's not possible to save it localy ither.

Any ideas?


Error saving Office 2010 files opened from SharePoint Server 2007


I have recently started testing Office 2010 and have found only 1 major issue - I cannot save any Office 2010 files opened from a SharePoint Server 2007 location.  Upon save I receive an error message saying "Upload Failed. This file wan not uploaded because the specified path was not found on the server." and the file is captured in the Microsoft Upload Center.  Using the Upload Center action 'Open Web Site' opens the site without problem; however, a all subsequent resolve actions fail.  Any ideas?


  * MS Windows Server 2003 R2
  * MS SQL Server 2008 R2
  *Office SharePoint Server 2007
  *MS Office 2010 Premium

Changing the graphics on the home page of a SharePoint site

When you create a site in Microsoft Windows SharePoint Services by using the default Team Site template, the home page includes two default graphics. A Windows SharePoint Services graphic appears in the body of the page, and a picture of a house in a circle appears near the site title. You can change these graphics to customize your site. Changing the smaller graphic requires a Windows SharePoint Services compatible Web page editor

Displaying SharePoint lists in Web Parts

When you create a built-in or custom list in Microsoft Windows SharePoint Services, Windows SharePoint Services creates a Web Part, a basic building block of a SharePoint site, to display that list. These Web Parts are called List View Web Parts. Windows SharePoint Services stores List View Web Parts in the site collection Web Part gallery. (The site collection Web Part gallery is the most central gallery of Web Parts for a work group. By default, the gallery name is the name of the site, such as "Our Team Site Web Part Gallery." )

Take a tour of your SharePoint site

What is a SharePoint site for?
A SharePoint site is a Web site that provides a central storage and collaboration space for documents, information, and ideas. A SharePoint site is a tool for collaboration, just like a telephone is a tool for communication, or a meeting is a tool for decision making. A SharePoint site helps groups of people (whether work teams or social groups) share information and work together. For example, a SharePoint site can help you:

Coordinate projects, calendars, and schedules.
Discuss ideas and review documents or proposals.
Share information and keep in touch with other people.

Six easy ways to customize your site using Web Parts in SharePoint

Becoming familiar with Web Part customization techniques gives you a range of page-customization choices. For example, you can customize your site's home page so that it displays the specific information that your team needs. You can rearrange the list items on the home page, add lists, and even change the images on the home page. As you become more familiar with Web Part Page customization techniques, you can build interactive Web Part Pages that makes the data in lists more dynamic and useful, and you can add new Web Parts that provide access to external data and Web services.

Working with SharePoint document libraries

Document libraries are collections of files that you can share with team members on a Web based on Microsoft Windows SharePoint Services. For example, you can create a library of common documents for a project, and team members can use their Web browsers to find the files, read them, and make comments. Users with Microsoft Office 2003 can check out and edit the files as if they resided on a local or network drive.

By default, your team Web site comes with a built-in document library named Shared Documents, which is listed on the Quick Launch bar as well as on the Documents and Lists page.

Out of the Depths of SharePoint's XML Hell

I described how a new open source tool called sporm significantly simplifies unit testing SharePoint. Making SharePoint unit testable is my absolute favorite feature of sporm because SharePoint is notoriously hard to unit test. But sporm provides other benefits as well and its ability to pull us out of the depths of verbose loosely typed XML hell and into LINQ excellence is next on my list of favorite features. So in this post I'll describe the pre-sporm technique of querying with CAML, how to query data using sporm, and finally how sporm supports SharePoint's unique architecture of allowing multiple content types per list and what that means to you.

Unit Testing SharePoint - Past, Present, and Sporm

As I described in SharePoint: The Wild West of Software Development there is a serious problem when you develop for SharePoint: ensuring quality through unit testing is really, really hard. And that's where a new open source tool just released today called sporm (SharePoint Object Relational Mapper) comes in. While sporm provides many benefits besides simplified unit testing I wanted to focus on this topic first, because sporm's approach, which models the entity framework in the way it supports POCO's, is a unique feature not available with other SharePoint tools like LINQ to SharePoint.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend