120mb .xls file taking long to open?

teatimecrumpet

Active Member
Joined
Jun 23, 2010
Messages
307
.xls file is:

120mb
180,000 rows
11 columns

Possible that it's an earlier version of excel? I get that error message when opening that says the extension is different than the format of the file?


My computer:
Windows 7
4GB Ram
Intel Core 2 Quad
2.66Ghz
64-Bit OS
Running Excel 2007

Any ideas? Haven't been able to open this file at all. This file is downloaded from Salesforce.com
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

sulakvea

Well-known Member
Joined
Jul 2, 2008
Messages
994
you sure its an XLS file? 2003 Excel can only hold ~65K rows.

i have no clue if its gonna work but can u change the extension to XLSM (or whatever it is Excel 2007 uses)?
 

Domski

Well-known Member
Joined
Jan 18, 2005
Messages
7,292
I'm guessing it's probably a csv file but I would expect Excel to accept that with an xls extension. It might be worth giving it a .txt extension then opening it through the text import wizard.

Dom
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,503
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
If you can't open it how do you know how many rows and columns it has?
 

Domski

Well-known Member
Joined
Jan 18, 2005
Messages
7,292

ADVERTISEMENT

If you can't open it how do you know how many rows and columns it has?

Maybe in a similar way to how you know the number of records and columns an Access query returns before exporting it.

Dom
 

teatimecrumpet

Active Member
Joined
Jun 23, 2010
Messages
307
If you can't open it how do you know how many rows and columns it has?


I ran a report on Salesforce. It'll only show the first 2000 records so I can see how many columns there are and it tells me how many records it found in total.

From the website I downloaded it through the option that says excel file. There is a .csv version I can download but I think the same thing has been tried with the same outcome.

Not at work right now but i'll try out the other suggestions later.

Thanks guys!
 

teatimecrumpet

Active Member
Joined
Jun 23, 2010
Messages
307

ADVERTISEMENT

Domski: Adding a .txt extension allowed me to use the wizard and open up the workbook. But it's fairly unusable in it's set up because all the data exists in the first cells of column A. And includes what looks like code for formatting.

It did open up rather quickly though < 1 minute.


Checked SF and reran the report. The two options I had for DL were "Excel Format .xls" or "Comma Delimited .csv"


And file encoding options:
ISO-8859-1 (General US & Western Eropean, ISO-LATIN-1)
Unicode
and some other asian languages

Update: I limited the number of column fields to what I absolutely needed still 180k rows but with about 6 columns now. Opens up in 2 minutes. But I'd still like to figure out how to open a larger file for the future.

Thanks guys,
Mike
 

Domski

Well-known Member
Joined
Jan 18, 2005
Messages
7,292
I would try the csv option and save the file as a .csv file.

This won't include any formatting but Excel should have no trouble opening it.

Dom
 

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,690
Office Version
  1. 2013
Platform
  1. Windows
Maybe the xls download fails if the # of rows exceeds the xls limitation of 65,536 rows (?). CSV would be my preference too, I think.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,939
Messages
5,525,741
Members
409,661
Latest member
pprabha

This Week's Hot Topics

Top