Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I noticed that the create date field of a list item is not returned when you create a data connection to it using Excel.

The technique I am using is to go to the list and export it from the ribbon to download the *.qry file. Then use that file in Excel to create the connnection.

Does anyone know of another way to get the create date imported into excel?

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

Make sure the Created Date field is in the view that the IQY is derived from. I've got a library filled with dozens of data sources from Sharepoint lists and the created filed is included be cause it was in the view when the IQY file was created.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.