.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

Comments disappear when File is checked-in on Sharepoint

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#
We use Sharepoint 2007 site to share Excel 2003 file with Clients. We have a Few cells in the Excel file which have comments attached. When we check-in the file, the comments still Exist. If we check out the file the comments still Exist. But when a few clients check out the file, the Comments dis-appear.

I am sorry I cannot be anymore specific as its an intermittent issue. Sometimes it happens and sometimes it doesnt. We are all using Office 2007 on Windows XP and the file is hosted on Sharepoint 2007 site.

PS. There are 3 Worksheets in the Excel file and the 1st worksheet which has the comments is password protected. The password is not shared and there is no easy way or a reason for the users/clients to delete the Comments.

View Complete Post

More Related Resource Links

Upload a File to a SharePoint Document Library - Part I

The following helper class demonstrates a few techniques that allow documents to be uploaded to a SharePoint document library programmatically without using the API or a custom web service. You don't need to specify a document library name, and it will create any folders specified in the URL as required. File meta data will be updated if any properties are passed.

ClientAccessPolicy file in SharePoint 2010

I am upgrading my Silverlight demo code from the old beta to beta 2 and see that there are a few new considerations for the deployment of ClientAccessPolicy.xml files. In a previous post I demonstrated how to do this for SharePoint 2007. The heartburn that I get with that approach is any site collection owner or designer can drag the file into the site collection and open the site up to unwanted client access issues. In 2010 the virtual path provider no longer serves the files from the root of the site collection

Insert image into Infopath form and save to SharePoint as PDF file


I have an InfoPath web-enabled form in MOSS 2007, that is integrated with a K2 blackpoint process for an approval workflow.

Once the form (a Purchase Order request form) has been approved in the K2 workflow process, I switch the form view to a "print-friendly" view for the requestor to view from the browser.  However, now I need to go one step further with this scenario:

1) I need to somehow insert/embed an image with the scanned-in signature of the approver (likely stored in a SP doc library) at the signature line section of my form.  Also, what are the security requirements for storing such images, but not granting all users access to these (e.g. only services accounts that need to access this for embedding into the form, etc.)?

2) Then I need to convert this final "print-friendly" view of the form (with the signature image) to a PDF document so that I can store it in SharePoint (and email it to the requestor using K2's email event capabilities).

Can anyone help me with a solution to both of these requirement, or point me to some resources for this (even 3rd party components are open-game).



File Attachments from info-path forms to Sharepoint document library


Hi Experts,

How to upload file attachements from info-path forms to Sharepoint document library?

I need to add attachement from local-PC/Any User to Sharepoint Document Library.


Any help please?? Appreciated




Can not perform this operation.The file is no longer checked out or has been deleted?

In my sharepoint designer 2007, when I try to check in a file, it give me the following errors:

Can not perform this operation.The file is no longer checked out or has been deleted.

Please advise me how to fix this problem?


Excel file published on Sharepoint


I want to use ExcelServices of MOSS to publish few XLS files.
The problem is if i want to open up the excel file it will not open in the web browser as I expected, altough i already click "Display as web page".
My MOSS instance is on a server without MS Excel installed on it.
The excel file was created using Excel 2003.
Any idea how to fix it?
Thank you very much,

Disregarding updates on non-checked-in entries in a sharepoint list (SPAudit)


Hey guys.

Okay, this is a little hard to explain, as the title might suggest.

I have an event receiver on ItemUpdated and ItemCheckedIn, which both writes custom SPAuditEntries. When CheckedIn occurs though - it comes with two update entries as well (one for added file, and one for a simple update to the list item I suspect).

I'd love to get rid of these entries. At first I thought it would be really simple, just put an if in the itemUpdated event receiver, and stop everything

if(SPListItem.CheckedOut = false) { //... do nothing }

However I couldn't find any way to ascertain the checkout-status of the listitem. My next thinking was, they hit almost at exactly the same time, so I could just crawl into the auditCollection, filter down to the specific listitem, user, and time (minus a second) and delete the two entries. But, sadly I found out I couldn't delete auditentries.

Anyone got any ideas?

How to show previouse user comments on the task form of a user in sharepoint Designer

I am using sharepoint designer for designing workflow. I have 4 steps. on each step a user write some comments for the next user. now I want to show all those comments on task form for the current user to whom the task has been assigned.

OpenSearch Descriptor File Generator for SharePoint Server 2007 Sites

Learn about the OpenSearch Location Builder Tool, which you can use to create an OpenSearch Description (.osdx) file to connect SharePoint Server 2007 sites to the Windows Client via the OpenSearch protocol.

Video: SharePoint 2010 File System

This video describes the SharePoint 2010 file system and integration with Visual Studio 2010. (Length: 3:23)

Word save file on SharePoint via mapped drive


Hi, I have a Document Library mapped to a drive letter. I am able to browse the drive through Windows Explorer. However when I try to save a document to the drive Word returns, 'Unable to connect to the Web server.' .  I have been unable to find any information regarding this error message. If I try to create a document in the Document Library through Windows Explorer and the mapped drive, I get a different error message: 'Unable to create the file 'New Microsoft Office Word Document.docx' There is no user session key for the specified logon session.' After I click OKand refresh the directory, a 0 KB New Microsoft Word Document.docx file has been created. When that file is opened, it is in Read-Only mode.


Windows Server 2003 R2
Webclient service started
Signed into the Microsoft Online Services Sign in Application
IE configured through the sign in application
site added to the trusted sites in IE

Thank you again for your input.

Can't save SQL Server Management Studio sql file back into Sharepoint Document Library

I created an sql query file in SQL Server Management Studio and saved it onto my hard drive.  I then moved that file into a Sharepoint Document Library so others on my team could use that query.I opened the file from within sharepoint, it launched SSMS.I made a change to the file and pressed save.here is the error message that comes up."The operation could not be completed.  The process cannot access the file because it is being used by another process"Am I doing something wrong?

"The file is not checked out" on page Postback

Hi there, I have a Publishing site with the Pages library set to "Require documents to be checked out".  As an administrator or member of the site, when i minimise/restore webparts on my page, then perform a postback operation (via some webpart on my page) i get an error saying:  The file is not checked out.  You must first check out this document before making changes. Its as if during the postback after minimising/restoring a webpart SharePoint wants to save that state! How do I stop this from happening?  Is there a personalization setting i am missing?   P.S. Here is a dummy postback operation if you'd like to test it, just paste it into a CEWP: <a id="Test" href="javascript:__doPostBack('Test','')">Test Postback</a>  

Microsoft.SharePoint.Client.File.OpenBinaryDirect - returns a 404 error if the file being requested

Hopefully someone can help with this. I'm using Sharepoint 2010. On the server I have manually created a folder in the "Shared Documents" folder called "bin" and uploaded a file into this folder If I attempt to access the files in this folder using the Microsoft.SharePoint.Client.File.OpenBinaryDirect function,  I receive the following error: A first chance exception of type 'System.Net.WebException' occurred in System.dll: System.Net.WebException: The remote server returned an error: (404) Not Found.    at System.Net.HttpWebRequest.GetResponse()    at Microsoft.SharePoint.Client.SPWebRequestExecutor.Execute()    at Microsoft.SharePoint.Client.File.OpenBinaryDirect(ClientContext context, String serverRelativeUrl). Any other files in any other folders under the shared documents folder are accessible. Here is my example code: ClientContext clientCTX = new ClientContext(SPURL);             //Pass the credentials to the client context             clientCTX.Credentials = credentials;             List DeployFilesList = clientCTX.Web.Lists.GetByTitle("Shared Documents");             CamlQuery caml

Sharepoint 2010 Enterprise - Word can not open file in sharepoint

Hi, In the library shared documents on my first teamsite i uploaded a word 2010 document. When i click on the document my Word starts up but i'm not able to open the document. i'm also getting the following error: could not open http://pcp/Shared Documents/cv.docx. When i upload a document via word (saving the document in the library via word) i can view it when i click on the document. But when i upload an existing document into the library i keep getting the error from above when i'm trying to open it.   Thanks TIM

Can't import VWI file from SharePoint Designer into Visio

Hi,   I have Visio 2010 Premium.  Am running SharePoint 2010 Enterprise. I have created a workflow in SharePoint Designer 2010.  I select the "Export to Visio" button.  A VWI file is created. In Visio 2010, I attempt to open the file.  However, Visio reports that it cannot read the file.   Please advise.

using SSRS Windows File Share subscription to send file to sharepoint

Hello, I'm looking for the simplest way to automate sending SSRS reports to a Sharepoint document directory.  I know a document library is not a real directory but I am able to run copy scripts into one using the virtual path thats shown when I do Actions-> Open in Windows Explorer. However when I set up a subscription to send a report to this directory, I get an error: Failure writing file \\intranet\projects\docs\test.pdf : The network name cannot be found.  Just checking if anyone knows if this should be able to work or not. Thanks
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