I am managing an Excel data file (Excel 2010) which contains more than 400,000 rows and 55 columns.

It is impossible to work with a Pivot table: I get a message that Excel does not have enough resources (I can't play with the pivot / refresh etc.)

I also tried to use the "Power Pivot", but didn't succeed uploading the file to the power pivot: I get all kinds of errors (Syntax errors etc...)

Anyone has an idea how can that be solved?