I have an Excel macro which runs fine on any XP machine using Excel 2003 or 2007. The same macro will not run to completion on a Vista machine. Without getting into too many specifics, the macro simply processes data contained on two worksheets of a XLS workbook and places the results on a third worksheet of the same workbook. There are no external dependencies in the workbook such as add-ons or data. The percentage of data processed on the Vista Machine varies each time the macro is run, but rarely exceeds 50%, and tends to slow down markedly just prior to halting. The total processing time on a specific XP machine (Intel quad core Dell T3400) is approximately 10 seconds . The Vista machine is a Gateway Intel duel core ML6720, which will typically halt in less than 2 minutes when approximately 50% of the data is processed. Has anyone had similar issues with Vista and Excel? If anyone is interested, I will gladly provide the workbook with the data and macro in question.
Thanks,
Richard