You don't say which version of Crystal you're using, but Crystal 2008 and lower only export to the earlier versions of Excel. If formatting is not as important, you could always export to CSV, which doesn't have the same row count limitations as the earlier versions of Excel, and then open the file in the new version of Excel.
-Dell