How to Export large data from excel?

[radian89]

Hi,

i'd like to know some solution for this, my

daily data generated is around 520 rows
yearly data generated is around 520*365 = 189,800 ~ 200k rows

column is 8 columns. planned to storing around 5 yrs data, it means around 1 million rows. this is pretty huge & going to slow down if i'm going to create pivot/charts/dashboard that goes for weekly, monthly, quarterly, yearly basis > if the database & report is combined in 1 single excel files.

is there any solution to create a separate excel file only for the report? sorry bit new to this kind of method.

please help
thanks a lot
warm regards

Adrian

 

[sandy666]

load incoming data into PowerQuery (limited by RAM only) then create what you want and when you want in Excel sheet