.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

Exporting MOSS 2007 List to Excel 2007

Posted By:      Posted Date: August 27, 2010    Points: 0   Category :SharePoint
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.

View Complete Post

More Related Resource Links

Exporting web from MOSS 2007 to WSS 3.0

Hi! I'm trying to export SharePoint web site from MOSS 2007 to WSS 3.0.

There are some problems, which prevent me. WSS doesn't include two features: DataConnectionLibruary and TransMgmtLib. This features are not avaible on WSS, so I tried to deactivate these features using site capabilities. It wo'nt help. Here is the exception text:

Could not find Feature TransMgmtLib
at Microsoft.SharePoint.Deployment.ImportRequirementsManager.VerifyFeatureDefinition(SPRequirementObject reqObj)
at Microsoft.SharePoint.Deployment.ImportRequirementsManager.Validate(SPRequirementObject reqObj)\
at Microsoft.SharePoint.Deployment.ImportRequirementsManager.DeserializeAndValidate()
at Microsoft.SharePoint.Deployment.SPImport.VerifyRequirements()
at Microsoft.SharePoint.Deployment.SPImport.Run()
at InfoCenter.ConsoleTestingApp.Program.ImportInfoCenter()

The question is: which way must I go to solve this problem? Is it really possible (I mean export from MOSS to WSS)? And what is the purpose of TransMgmtLib feature? Thanks.

Cannot List SSAS Catalogs in Excel 2007

I am trying to access SSAS 2005 through excel on a client computer.  I get the following error message:  The data connection wizard cannot obtain a list of databases from the specified source.  It looks like I connect, but I cannot list any of the catalogs.  Both catalogs are migrated from a sql2000 database.    I ensured that the account has a browsable role through the roles in SSAS.  Interestingly if I create a UDL file with a connection to ssas and choose existing connections and specifiy the udl file I can access the specific ssas catalog.  In creating the udl file I cannot see the catalogs, but I can type in the catalog name which connects me and allows me to browse the cube using excel.  Unfortunatley, my users use other applications besides excel which don't allow access through udls.  Any help would be appreciated.

MOSS 2007 and Word/Excel 2003

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          

MOSS 2007: list column that lookup to multiple documents stored in doc library

Hi All, I'm trying to understand how to customise MOSS to achieve the following: I need to lookup from a list to multiple documents stored in a documetn library. Example: - List item 1 --------> Lookup to Doc 2                   --------> Lookup to Doc 5 - List item 2 --------> Lookup to Doc 3                   --------> Lookup to Doc 5                   --------> Lookup to Doc 8 - List item 3 --------> Lookup to Doc 1 How can I achieve this? is it possible that in the lookup I have a "search" option? Thanks all Vit

How to get a list of installed MOSS 2007 updates?

We have several problems with our MOSS 2007 installation and operation and since we found out that two identical sharepoint servers (production and test) that had same updates applied have different Search_DB databases (they have same name function with different number of parameters, for ex.) we have a single idea of what can be the cause: Somehow, windows update or other quirk, an update or hotfix got applied to one of the servers.  Strange thing is, noone of our employees seems to know, neither google seems to know, how do we exactly get a list of installed updates on the MOSS 2007 installation.   So, simple question: HOW? How do we get a complete list of changes (hotfixes, servicepacks, patches) done to an installation of MOSS?

Consume MOSS 2007 list to 2010

Hi all, My end goal is to display a list in SharePoint2010 .... but the list actually originates from SharePoint2007. I thought it could be as easy as creating BCS to the SP2007 list web service (/_vti_bin/Lists.asmx) but BCS has issues with the complex data types and based on other threads this isn't possible.  We've been able to create a data source to the web service and display the list contents on a custom aspx page, but this isn't exactly our end goal. Is there a best practice for this type of thing?  Or do we have to go down the path of creating a custom web part while consuming the web service directly or the SOAP data source we've created?+ Note: Migration is not an option at this point... integration is our current path. Any help is appreciated. Thanks, Eric

Reg Upgrading List of MOSS 2007 to InfoPath 2010

Hi, Actually right now there is Newform.aspx of the list in MOSS 2007 through which we are collecting the data from the user.Now our customer is planning to migrate the application to SharePoint 2010 so i just want to know so that can we get a easy support to implement in InfoPath 2010 compared to the list of MOSS 2007 Thanks & Regards, Sudheer

Range or List Filtering via SSAS cube in Excel 2007

Hi All, A client has posed an interesting question, as current users of business objects webi they can filter the results of a cube/universe by copy and pasting a range or list of values seperated by a ';' into a list filter that is availble. e.g. product2;product533,;product029;product8389 etc etc. The list can sometimes be hundreds long. How is that same function acheived in browsing a ssas cube in excel 2007, all I can see is that a user has to use the drop down list and individualy select the values they want. This does not seem like a great method! Any ideas? They are using SQL / SSAS/ SSIS/ SSRS 2008 R2 Cheers DC

Upgrade List from MOSS 2007 to SP2010

Hi, I have a list in MOSS2007 and I want to save it as a template to use it in SharePoint 2010. But, the problem we can't use stp file in SP2010. So, did you have idea about creating wsp package in 2007 for existing List ? I have seen this article but it talk about Discussion List Feature. Thanks 

Is there a way to upload multiple files to a SharePoint List Item in MOSS 2007? I can not use Doc Li



Is there a way to upload multiple files to a SharePoint List Item in MOSS 2007? I can not use Doc Library because of the funcationality.

Thank you,



Uploading Multiple Documents To a List Item in MOSS 2007


Is it possible to attach multiple files to a single item in a List Webpart. If So how?

We are using MOSS 2007 and the attachements will be word dorcuments.

Excel 2007 Cubeset function needs to pull list based on part of field value (ie contains, wildcardin


I have a Cube with a field called 'Item Code'.  This field is six characters in length.  The first two characters differentiate what kind of product it is.  I am building my reports with cube functions.  I do not want to use a pivot table to retrieve the list by using the 'contains' or 'begins with' label filters.  Is there a way to use the cubeset function with left, mid, right functions?  I realize that it can be set up in the cube as a separate field, but I am not able to update the cube.  Below are my examples - 'All Products' and 'Product R3189S' work fine, but I need to retrieve 'Products starting with R3'.

=CUBESET("Financials Sales Cube", "[Product Dimension].[Item Code].[All Product Dimension].children", "All Products")

=CUBESET("Financials Sales Cube", "[Product Dimension].[Item Code].[All Product Dimension].[R3189S]", "Product R3189S")

= CUBESET("Financials Sales Cube", "[Product Dimension].[Item Code].[All Product Dimension].[R3****]", "Products Starting with R3")

Thank you in advance.


List privileges temporarily disappear after installation auf MOSS 2007 August 2010 CU


Hi all,

after installing the August 2010 CU for our English Sharepoint 2007 farm I randomly have the list menu buttons "New" and "Settings" missing.

The farm consists of two frontend servers, one backend (all three W2003R2 x32) and a SQL 2005 x64 database, also running Windows server 2003.

This appears for all users, including the site administration account. Strangely, after about 10 .. 20 minutes, the buttons re-appear and everything works fine.

Since I installed the August 2010 CU two weeks ago, I have had three occurrences of this phenomenon. Sharepoint Event Logs show no error at the time. IISReset did not fix the issue, it just "went away" after a short time.

Did anybody else experience this issue? Does anybody have a hint where to look for errors here or what might cause this?


Many greetings,



exporting to excel 2007


hello champs

i want to export the datatable to excel 2007

i did it in 2003 version.but it is not working for me in case of 2007

i tried Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"

but with no success.

any help... 

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

Unable to use Managed Property mapped to Choice Dropdown list column in MOSS 2007


I have a choice list column containing dropdown values. I crawled the content source and created Managed Property to map it.

Also Configured Advanced Search webpart to display the property. But when I pick the property and perform search with values then no results are returned.

Can any one can help me out.?

Thanks in Advance.!

SharePoint List Search in Moss 2007






Is there anyway to search the specified sharepoint List in the current site in MOSS 2007?




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