Forum Discussion
Helper IExcel memory
Hi, Dennis_Pedersen
I think Excel is capable of handling much larger amounts of data, here is some documentation which states that the .xls file format has a limit of 65536 rows per sheet of paper and the .xlsx file format has a limit of 1048576 rows per sheet of paper; you can try upgrading Excel or just work with your data in Power BI Desktop.
What to do if a data set is too large for the Excel grid - Microsoft Support
Excel specifications and limits - Microsoft SupportBest Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi, Dennis_Pedersen
I think Excel is capable of handling much larger amounts of data, here is some documentation which states that the .xls file format has a limit of 65536 rows per sheet of paper and the .xlsx file format has a limit of 1048576 rows per sheet of paper; you can try upgrading Excel or just work with your data in Power BI Desktop.
What to do if a data set is too large for the Excel grid - Microsoft Support
Excel specifications and limits - Microsoft Support
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Dennis_PedersenNo I do not think it is a general problem with excel.
We normally handle much more data.
So it has something to do with a problem when excel is connected to a analysis service cube