.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

MOSS 2007 and Word/Excel 2003

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :SharePoint
Hi, I am working with MOSS 2007 and building a context webpart which contains links to various places. One of the the links is trying to go to a Bookmark in a Word 2003 document. Upon attempting this it only goes to the top of the document and not to the expected bookmark location. I then tried to define a named range in an Excel 2003 file and had Sharepoint point to the named range. The same behavior occurred, it simply went to the top of the document. Here is a code snippet which points to the excel name range called Base: <A href="http://tserver4/sites/HALBI/GON/Shared%20Documents/Parts.xls#Base"> Does anyone know of any issues with this scenario? Thanks, Larry          

View Complete Post

More Related Resource Links

Display the Version of a MOSS 2007 Sharepoint document in Word 2007 and Excel 2007

Do somone have a step-by-step solution to this problem;   I have a liberary in SharePoint with version controll. In this liberary I have both Word and Excel documents.  Displaying the metadata from created columns are no problem, but  displaying the Version of the document generated by SharePoint is worse.  I do appreciate if someone can help me with this problem.

Exporting MOSS 2007 List to Excel 2007

When doing the export, the columns "Item Type" and "Path" are automatically displayed in the sheet.  Is there anyway to suppress these fields from exporting automatically?  I'm sure this has already been asked before, but I couldn't find anything after much searching (perhaps I'm using the wrong keywords).  Any help would be greatly appreciated.

Office 2003 integration with MOSS 2007



All my documents are opening as read-only when I open from SharePoint sites even when I click on "Edit in ..." option on some machines.

The users seem to have correct permissions on the site.



Office 2003 integration with MOSS 2007


Hi ,

All my files/docs in MOSS 2007 open as read-only with Office 2003 standard edition in some machines.

The user seems to have sufficient permissions to edit but still not able to do so.

Any suggestion?




Install MOSS 2007 and ProClartity 6.3 (PAS6.3) on the same Microsoft Windows 2003 Server

An install of MOSS 2007 and ProClartity 6.3 (PAS6.3) on the same Microsoft Windows 2003 Server seems to be problematic. MOSS 2007 creates a default website and stops the normal default website. As soon as PAS 6.3 is installed it installs to this stopped default website. How can I overcome this issue?

MOSS 2007 to SharePoint Server 2010 Hybrid Upgrade Approach on Windows Server 2003 x64

There's some guidance circulating about upgrading to 2010 with a mix of In-Place and Database Attach upgrade methods. My Central Admin and SharePoint Web App are on a 64 bit server, but it's running on Windows server 2003 x64 and not on Windows Server 2008 or 2008 R2. SharePoint Team Blog says Server 2008 or 2008 R2 is required for SP2010. If I want to do the hybrid upgrade approach, is it possible to first upgrade the OS to Server 2008 R2 on the server where my Central Admin and SP Web App runs?  Or will this break MOSS 2007?

Document is read-only in SharePoint, but user sees "check out" option in Office 2007 / Word / Excel

I am finding that when there is a document library in SharePoint with checkin/checkout required, if a user with read-only ("Visitor") permissions opens a document from that library, the document will open as read-only in Word, Excel, etc., but the user will see the "Server Document" bar with the message "To modify this document, you must check it out" and the "check out" button.  When the user tries to check the document out, they are asked to authenticate, and then receive the error "Cannot perform this operation.  The file has been deleted or someone else has it checked out."    How is it possible to prevent a user with read-only rights in SharePoint from seeing the "Check out" option in Word or Excel?

How to Convert Excel 2003 (.xls) format to Excel 2007 (.xlsx) programmatically in asp.net


Hi everybody

I am using a function to save dataset tables to excel files (some xml method http://www.codeproject.com/info/search.aspx?artkw=xls+to+xlsx&sbo=kw ) in xls format(excel 2003) but the excel file which is created taking 10 times more file size than conventional one.

And after that when I am converting to excel 2007 format I am getting the normal size for that file.

Now can anyone tell me how to convert excel 2003 file format to excel 2007 file format programmatically through asp.net

Thanks everyone in advance.


Exchange 2003 Inbox and Calendar webparts for MOSS 2007


I've created one Inbox and one Calendar wepbart as descibed here:


using  OWAInboxPart and OWACalendarPart (code below).

When deploying them and placing them on the same page, only one of them will show anything. It looks like the last added webpart works, while the other won't.
If any one of them is placed alone on a page, they work as expected.

Does anyone know how to make them work togheter on the same page?

Thank you for your time!

Best regards,
Hans Erik Storeide

Inbox wp:

using System;
using System.Runtime.InteropServices;
using System.Web.UI;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Serialization;

using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;
using Microsoft.SharePoint.Portal.WebControls;
using Microsoft.SharePoint.WebPartPages;

namespace Inbox
    public class fmno_Inbox : System.Web.UI.WebControls.WebParts.WebPart

Has anybody experienced problems opening 'protected Excel 2007 worksheets in SPS 2003?


I have added the doc icons and MIME types to my SPS2003 farm and now it works properly with Office2007 documents, with the exception of 'protected' Excel files.  In those cases where the Excel file contains a 'protected' worksheet, the user can open the doc, unprotect the worksheet and make their edits.  When they 'protect' the worksheet again and try to save the file, they get an alert that the destination file is 'read-only' and they must save it with a different name.

This only happens for 'protected' Excel 2007 docs residing on an SPS2003 site.  Protected Excel 2003 documents work fine, as do unprotected documents.  Any help y'all can be is greatly appreciated.  I only have two users who are using the protected worksheets, but they are the most vocal of my users.

Help to manage migration from farm WSS 2.0/MOSS 2003 to farm WSS 3.0/ MOSS 2007



we need to move an application (only a site collection/portal site)  hosted in farm using  WSS 2.0(SharePoint Portal Server 2003 integrated with Project Server 2003) to a new farm where is installed WSS 3.0 and SharePoint Portal Server 2007.

We do not care at all about the part managed by Project Server 2003 . We are interested to obtain all lists, items and users information stored in the application (basically all the content part managed by MOSS 2003).

Which is the best strategy to get the job done ?

We have tried these steps to check if our strategy could work but it didn’t:




Hi All,

We have applied the ADFC successfuly on our Moss 2007 environment. But we are not able to open the document in Office 2003 component.

But all the document are getting open in Office 2007 component. Any help or work around?


Unable to open an Excel File in Sharepoint MOSS 2007


I am unable to open an excel file in Sharepoint (MOSS 2007). All other documents work fine. As far as I know there was no change on the Server at all.

Excel found unreadable content in 'stuff.xls'. Do you want to recover the contents of this workgroup? If you trust the source of this workbook , click Yes

When I click YES >> It says "Excel recovered your formulas and cell values, but some data may have been lost." And then a link to an xml file , which reads :

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
  <summary>Errors were detected in file 'http://server_name/Project_name/Shared Documents/abc - def/Phase 5/Track/stuff.xls'</summary>
- <additionalInfo>
  <info>Excel recovered your formulas and cell values, but some data may have been lost.</info>

Now this has resulted in huge loss of data and I can see New numbers in the cells which is very strange!

Is there a way I can get it back ? I do not have a

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 :-)


Moss 2007 and Infopath 2003 client


System config:

SharePoint 2007 SP2 - 64 bit Standard edition

2 WFE, 1 APP/index,  Clustered SQL DB Servers (SQL 2005)


Issues is with Infopath forms saved to a document library (NO FORMS SERVICES ENABLED - MOSS Standard license), no code behind, just XML based form with a number of fields in it linked to an xsn that is located on another server entirely.

Client machines are IE 6 Infopath 2003


When form is opened by an owner - works fine, client opens no issue

When form is opened by a contributor - unless checked out first or if the "Require checkout before allowing editing of file" is disabled works fine

When form is not checked out to contributor or if the user if a viewer the error is:

"Infopath cannot open the following file:<filename>.xml. The file does not appear to be an infopath form ."

Show details:

"The processing instruction in the file is missing or invalid"

I tried a couple tests, I logged into Windows as a user who had viewer rights and then logged into MOSS as a user who has owner rights. Issue still happens. So I am assuming there is a second call being made by the InfoPath client using the windows identity and integrated auth.

If I download the file to my desktop it opens just fine. I cannot determine what ch

Word 2003 vs Word 2007 with Sharepoint 2007


My scenario is:

Have SharePoint 2007 website through which we access our Word documents and currently use Word 2003 to open them.  Users who edit documents use check-in and check-out and publish new versions as and when needed.  Users who just use the documents then access these as read only, but are able to make amendments to add names and addresses etc.

We're currently testing Office 2007 as the integration capabilities with SharePoint 2007 are much better, but we have found that users who access the documents as read only can no longer make ANY edits.  The only way they can is to check out the document, which they are not allowed to do as they are not editors.  So basically we have documents created that users cannot use...

In addition, the Word documents we have stored on the SharePoint site have the DLCPolicyLabelValue field in the footer that links to the item properties in the Sharepoint list to provide the barcode value and current version number.  Whilst ok in Word 2003, Word 2007 doesn't allow these fields to update.

Cannot install MOSS 2007 on Windows server 2003 SP2



I try to install moss 2007 on a developper workstation:

An error occured in the step 2 of the installation (installation of the administration database)

The error is as follow:


Exception: System.Data.SqlClient.SqlException: the procedure or function 'proc_SetDatabaseInformation' expected the '@Value' parameter, wich is not provided

i first try with an sql server 2005 database instance, then with an sql server 2008 database instance. Same problem.



In the log file, i can see this message before the exception:

Creating a new farm with config db SharePoint_Config content db SharePoint_AdminContent_59286dfd-6ead-46e6-8268-7b4c0f5025b1 server XXXXX for farm mode

The thing is, i do not want a farm mode installation, but the install wizard do not allow me to choose a non farm install.

Maybe this is non relevant, i don't know.


Thanks for your help



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