inserting rows when refreshing external data

I want to import my iTunes media library as a tab-delimited text file and then add further information about each recording to my worksheet. Simple enough.

The problem comes when I refresh the external data and the iTunes text file contains new rows (ie. new songs). The extra info I've added stays where it is so everything below the new row is in the wrong place.

I would have thought that checking the option 'insert entire rows for new data, clear unused cells' under data/connections/properties would take care of this for me but it doesn't seem to.

What am I doing wrong?

Chris.

(Excel 2007 newbie)

Hi, I'm starting to think I'm going to need to get stuck into VBA anyway, i've discovered that a nice iTunes object exists, but If anyone knows why this doesn't just work as i want without programing I'd love to hear it!

Cheers, Chris.