SharePoint University

I have created an issue tracking list that I need to export to Excel for discussion at weekly meetings. I'm able to export the list without a problem. However, on the spreadsheet the field that contains the latest update does not export the system generated name/date/time stamp that is created on the SharePoint site.

 Any idea how/if I can get this information to export as well? Thanks in advance for any assistance.

Regards,
PJ

If you have Access 2007, you can also use this as a reporting mechanism. I believe it will return all of the underlying data.

Also, what is included in your view that you are exporting to Excel? If you do not have the Modified field in the view, I don't believe it will be exported.

The modified field will give me the date/time but not the "by whom" information. I'm getting the text of the latest update but not the system generated portion. This issue log is used by many individuals in multiple departments and multiple states. When reviewing the log it would be helpful to know who made the most recent update and when it was made.

 I don't have Access 2007. It almost took an act of congress for me to get Excel. LOL

 Thanks so much for assisting me with this!

Can you add the Modified By to the default view? I just did this in a test environment and exported to a spreadsheet. It worked beautifully.

Excellent suggestion! However, not quite the solution that I'm looking for. I would prefer to not add additional columns as the spreadsheet is already at 55% on a legal size document, so real estate is a consideration. 

The information is captured in SharePoint in the same field that contains the latest update. It's just not exporting it. Ideally, I would simply like to have the data as it appears in the field in SharePoint exported to the Excel spreadsheet.

 Here is an example of how is appears in SharePoint:

Deloatch, Phyllis (10/10/2007 10:21 AM): Removing Lisa McCormick as an issue owner

Here is an example of how the same field appears in the exported Excel document: