Had a funny importing issue today. After upgrading to 9.0C (20100511), a user called today saying what has changed because I can't upload my payroll data today. (Person has done it for several months without error). It took a bit but the amount cell shows 3718.50, but the cell acutally contains:
='C:\WINNT\Profiles\camah\Personal\[Payroll Worksheets.xls]Seattle'!$C$14+'C:

Once I realized this and copied the data to a new spreadsheet, using paste special | Values, it accepted the workbook as valid but all the date formats fail. It would report the serial date number 40298 (this is april date code, but it showed the date code for May 31, 2010). In my template I had to set it up as user defined mm/dd/yyyy when we first started using the import feature several years ago. Today I had to change the template to Win Format: dd/mm/2010.

Was able to get the file to import correctly.

Any other changes in the batch importing that I will find out about tomorrow when we do the bulk of our importing.

Thank

Jeffrey Marshall
Commonwealth Ins. Co.