Large spreadsheet hangs on opening

  • Thread starter Thread starter wynnb944s2
  • Start date Start date
W

wynnb944s2

I have a spreadsheet about 3.5mb in size with about 15
sheets in the workbook that I have created over time. Now
the spreadsheet will not open. It just hangs after I say
to enable the macros in the dialogue box. When I do a
Control-Alt-Delete it will say that Excel is not
responding.

In the process of trying to open it will create about 1000
temp files in the Windows Temp folder. Any ideas on how
to open it.

Thanks

Wynn
 
Hi Wynn,

Try this methods posted by Jan Karel Pieterse in this NG.

------------------------------------------------------

Options to try and open a corrupt file

- Set calculation to manual
- open the file, but disable macros (assuming you've set
macro security
to medium: Tools, Macro, security)
- As soon as you've clicked the disable macros button,
press
control-pageup or control-pagedown, thus changing sheets.

If that does not work, try creating a link to the file:

='c:\my documents\[MyFileName.xls]Sheet1'!A1

and copy right and down. This at least gets you the
worksheets values.

if you don't know the sheet names, enter this:

='C:\PathToFile\[MyFileName.xls]'!A1

and press enter

If XL (2000) is able to extract them, it will prompt you
for a sheet
name.

Sometimes the Excel viewer, Word or even Internet explorer
(v5) enables
you to open the file and copy information out of it.

If the file is not protected, maybe you can open it with
OpenOffice
(www.Openoffice.org).

Also, Excel XP can sometimes repair XL files with trouble.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
----------------------------------------------------------
end of post



Regards,
Shailesh Shah
http://members.lycos.co.uk/shahweb/
(Excel Add-ins)
 
Back
Top