i've found a migraine trigger

[rone]

Repairing the Contacts Spreadsheet

This should be done every time before publishing

• Copy the new REVSHARE_CONTACTS_<DATE>.xls to a Windows system

• Open the file in Excel

• Save file as a Tab Delimited (*.txt) format (answer "yes" to losing all the formatting- that's the whole point of doing this)

• Close Excel

• Re-open Excel

• Import/open the  REVSHARE_CONTACTS_<DATE>.txt file

• Save the file as an excel 97-2003 workbook.

This will create a file that should always validate and import correctly

Comments

[eagle]

I would be so tempted to propose the optimization of always saving the file as a Tab Delimited file each time one changes it, pointing out that this saves several steps, but I'm not sure that I could keep a straight face through the entire conversation as required to pull that off.