We have been using Excel 2007 to massage data extracted from a ticket db that we use. The data is brought in as text, then sorted and we run a macro to convert some date columns to text and save it to a file, then import the file to a Database. On machines running 2007 this works without issue. However when we run the same process / macro on an Excel 2010 wkstn it causes issues with the import. The import gives an error saying there was a problem with column meta data any time we use 2010. I would like to get a look at the column meta data but I am not a programmer so don't have those skills yet. I have been using Document Inspector but it will only show me that it found some personal info in the document and doesn't show the column meta-data.

Does anyone know how I might determine (as easily as possible - I don't program...) the differences between a 2007 file and a 2010 file so we can correct the process for our 2010 users to be able to upload this data?