Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can not open file (Critical)
I have a large file (Excel 97) with links and macros (written by data access providers). This file was working fine and closed all right last Sun. Now as I try to open it, Excel tries to open it for about 5 secs and crashes with the dreaded "The Instruction at "0x301ebxxx" referenced memory at "0x00000000". The memory can not be read". I can not open the file by disabling the macro as the file seems to have a few Excel 4 macros. Any suggestions? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can not open file (Critical)
Hi jasanin,
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, Shah Shailesh http://members.lycos.co.uk/shahweb/ *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
Critical requirement. | Excel Worksheet Functions | |||
Critical graph | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) |