![]() Think of Data Model as a black box where you can store data and Excel can quickly provide answers to you.īecause Data Model is held in your computer memory rather than spreadsheet cells, it doesn’t have one million row limitation. Introduced in Excel 2013, Excel Data Model allows you to store and analyze data without having to look at it all the time. Excel data model can hold any amount of data But that doesn’t mean you can’t analyze more than a million rows in Excel. You may know that Excel has a physical limit of 1 million rows (well, its 1,048,576 rows). ![]() How-to handle more than million rows in Excel? As part of our Excel Interview Questions series, today let’s look at another interesting challenge.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |