Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Export from MOSS 2007 to Excel 2010 - Missing Columns

Posted on 2011-04-19
5
Medium Priority
?
1,126 Views
Last Modified: 2012-05-11
Hi,

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
Created By
Modified
Modified By
Type (icon linked to document)
Version
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).

Thanks,

Joe
0
Comment
Question by:satandog
  • 3
  • 2
5 Comments
 
LVL 6

Accepted Solution

by:
scifo_dk earned 2000 total points
ID: 35427144
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.

//Scifo_dk
0
 
LVL 1

Author Comment

by:satandog
ID: 35428493
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?
0
 
LVL 6

Expert Comment

by:scifo_dk
ID: 35428538
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)
0
 
LVL 1

Author Comment

by:satandog
ID: 35429015
Thanks for the help. It is helpful to have confirmation that they should be able to export.
0
 
LVL 6

Expert Comment

by:scifo_dk
ID: 35430828
Your welcome :)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

571 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