I have a workbook that works fine on my PC (XP Excel 2007). When the workbook is used on a Windows 7 64 bit Excel 2010 PC on the same network it is sloooooooow. It hangs for ages when doing most things.
I have narrowed it down somewhat and have copied a single sheet of data that has some transactional data plus some columns of formulae alongside each row and if I try to filter the sheet e.g. for all start dates in 2010 it takes forwever on the 2010 PC and the same when you unfilter it.
On the 2007 PC it just flies through.
Has anyone come across the same/similar problem???