Handling a big Excel File

0

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?

yaelsh

Posted 2011-06-27T18:05:04.123

Reputation: 1

2As of 2007, Excel is supposed to handle upwards of a million rows...of course, this is system dependent. – slotishtype – 2011-06-27T18:21:23.313

Answers

2

Sounds like the data should be in a database.

Linker3000

Posted 2011-06-27T18:05:04.123

Reputation: 25 670

Yep, get an MS Access database going, and import your spreadsheet. – Breakthrough – 2011-06-27T18:57:11.087

Asked: 2011-06-27T18:05:04.123

Viewed: 375 times

Active: 2011-06-27T18:30:35.780