ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to open EXTREMELY large .XLS file? (https://www.excelbanter.com/excel-discussion-misc-queries/167492-how-open-extremely-large-xls-file.html)

[email protected]

How to open EXTREMELY large .XLS file?
 
Hello all, i've browsed through the groups but can't find a specific
problem like my own;
I have an XLS file that is 500+ MB, it has a few hundred thousand
rows. This file takes hours to Open in Excel and when it does only
displays the first ~65,000 rows (as opposed to all). I know how to
extract data from it but IS IT POSSIBLE to view the entire spread
sheet as it was meant to be viewed?

Any help would be appreciated. Thanks.


All times are GMT +1. The time now is 03:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com