Cannot open file over 6mb

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a fill-down formula that goes all the way to the bottom of the
worksheet and now I can't open the file at all. I need the data that is
contained on the worksheet's first 500 rows. I've tried opening in safe
mode, but that doesn't work. Is there a way to get to it, import part of the
big file to another workbook? Excel stops responding on every attempt to
open the file. Please help!!!
 
Try Tools / Options / Calculation --> Manual

and then try opening it.

If not you can just create a new file and put a link into cell A1 on your
closed workbook and then copy across and down to get the data eg:-

Create a new file with the exact same sheet name as the sheet in the duff
workbook, and with the exact same filename as the duff one but different by
say one character (eg add a 1 to the end of the filename) and save it in
exactly the same place as the duff file. In another workbook link to cell
A1 of the new workbook and then close the new workbook. Now edit the link
such that you remove the 1 and hit enter. Copy across and down and you
should get your data back.
 
Maybe OpenOffice (free) can open it:
http://www.openoffice.org, a 60-65 meg download or a CD

If you know the name of the worksheet and you're not concerned with formulas or
formats (just values), you could try this:

='C:\My Documents\excel\[book2.xls]Sheet1'!A1
Change the folder/workbookname/sheetname and drag down 500 rows and as many
columns as you need.

This formula will return 0's for empty cells.

You may want to use a slightly different version:

=IF('C:\My Documents\excel\[book2.xls]Sheet1'!A1="","",
'C:\My Documents\excel\[book2.xls]Sheet1'!A1)

This formula checks to see if the cell is empty and returns "" instead of the 0.

===
You may want to try a newer version of excel than the one you're using. Each
newer version seems to open problem files a little better.
 
Back
Top