Handling BIG file

Hi All

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 massage that Excel do not have enough sources (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 off errors (Syntax errors etc...)

anyone has an idea how can that be solved?

thanks a lot

Hi and welcome to the board

I suppose you are using XL2007 or 2010. please update your profile accordingly.

Also adapt your title to b a bit more descriptive of your problem