I have been using offline cube files (.cub extension) to act as the data source for excel 2007 / 2010 pivot tables running under Windows XP, Vista and Windows 7 (32 bit)

However I am now trying to use these same cubes and excel files with Excel 2010 BUT running under windows 7 64bit. When I try to connect the .cub file does not link - Most sites seem to say that this is a problem with the 64 bit version of Windows and to revert back to the 32 bit version this seems quite drastic has anyone else come across this if so any ideas?