How to handle data with more than 4 million lines in excel

[Punjabixlvba]

Hello,


Can somebody help me that what is the best way to handle data with more than 4 million lines in excel other than keeping separate multiple worksheets ?

Thanks,

Punjabixlvba

 

[RoryA]

What do you want to do with it? I would probably suggest storing it in a database or CSV file and then querying it as necessary.

 

[Punjabixlvba]

What do you want to do with it? I would probably suggest storing it in a database or CSV file and then querying it as necessary.

I have to create Pivot Table of very long data having more than 4 million lines

 

[RoryA]

You can create pivot tables using external data, so no need to keep it in Excel.