I am currently using MS Excel 2007and have configured the "save as" default to be "xlsx".

However, when I import (copy/paste) a .csv file over the 2003 limit (65k), it will only show the first 65k as opposed to the 100k records.

Is there a certain setting that needs to be changed to allow for this?