Export from MOSS 2007 to Excel 2010 - Missing Columns

Posted on 2011-04-19
Last Modified: 2012-05-11

I am exporting a SharePoint list to Excel 2010. When I export the list a number of columns are missing in the resulting Excel file.

Category (linked to item with with edit menu)
Content Type
Created By
Modified By
Type (icon linked to document)
Category (linked to item)
Edit (link to edit item)

The SharePoint list has 117 columns and all are exported but the ones listed above. I believe that these are all standard system generated SharePoint columns (except Category which a renamed Topic column) but I cannot find any documentation that indicates that these columns should not be exported.

So the question is - is there a reason why these columns are not being exported and is there a way to have them export (without writing code).


Question by:satandog
    LVL 6

    Accepted Solution

    Try and create a new view containing only those columns.

    Only the columns shown in the current view are exported, so this will tell you if theres something wrong with your view, and if they CAN be exported.

    To my knowledge, they should be exportable.

    LVL 1

    Author Comment

    I should have thought of that...

    They do come into the new view. Any idea why they might not export from the current view? Is there any view setting that might impact the ability to export a column?
    LVL 6

    Expert Comment

    No to my knowledge. You should be able to export all the columns from your view.

    Are you sure that these columns are visible in the view you're exporting from?

    if they are, then try and disable some of the other columns to see if you might have hit some kind of boundary (although you shouldn't)
    LVL 1

    Author Comment

    Thanks for the help. It is helpful to have confirmation that they should be able to export.
    LVL 6

    Expert Comment

    Your welcome :)

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    VBA Excel Gantt 1 30
    copying from excel to word 2 30
    IF OR formula Excel 8 24
    add a password to open excel after 60 days 8 27
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now