Excel File Cannot Open

alyy8128 · 16th Apr 2008, 11:33 AM

Very funny, I received a excel file from my client (Korean). But that Excel file is

, most of the time when i double click it, it will crash my Excel.

It will ask whether am i allow the Macro or not, but no matter what i choose (Enable or Disable), it will also crash, and prompt to send error report to Microsoft.

I said most of the time, because it sometimes can be open

. I'm using Excel2000. I'm sure something is running behind the file, is there anyway to remove the embedded Macro without opening the file?

I attached here is a automated error generated by Microsoft.

belikethat · 17th Apr 2008, 01:26 AM

probably file corrupted, try using openoffice to open

and me no see the error u mentioned..

btw marco could be dangerous

Zenphic · 17th Apr 2008, 09:17 AM

Yeah, it's possible that it's corrupt. Try opening it via File > Open then next to the button Open, there a little arrow, click it and choose "Open and Repair". This is on Office 2003, not sure if Office 2000 has this. You might want to give OpenOffice a try also.

You might also want to try what's written under "Fixing Corrupt Files" in this page:
Excel 2000 Problems

Adrian Wong · 18th Apr 2008, 01:22 AM

You might also want to check if you have installed the Korean font. Even if the file is supposed to be in English, he/she may have accidentally put in a single Korean letter or something like that.

alyy8128 · 27th Apr 2008, 01:25 AM

Anyway, thanks all for your kind suggestion. They problem is still there, but I had quickly copy the data out from the worksheet to another New Created file (when i can open that file). So i still can continue my job without open that stupid file again.

alyy8128 · 28th Apr 2008, 08:07 PM

I think is that company include some "security" features on their file. They just sent me another file, but totally cannot view what is that. Then, after i request to re-send, they just apologise that they forgot to remove some kind of encryption on it.

Mac Daddy · 29th Apr 2008, 06:40 AM

Quote:

Originally Posted by alyy8128

I think is that company include some "security" features on their file. They just sent me another file, but totally cannot view what is that. Then, after i request to re-send, they just apologise that they forgot to remove some kind of encryption on it.

That makes sense did you mention the problem with the other file ?

16th Apr 2008, 11:33 AM	#1 (permalink)
alyy8128 Just Started Join Date: 22 Jan 2006 Location: Senai Johor Posts: 64 Reputation: 12 Rep Power: 0	Excel File Cannot Open Very funny, I received a excel file from my client (Korean). But that Excel file is , most of the time when i double click it, it will crash my Excel. It will ask whether am i allow the Macro or not, but no matter what i choose (Enable or Disable), it will also crash, and prompt to send error report to Microsoft. I said most of the time, because it sometimes can be open . I'm using Excel2000. I'm sure something is running behind the file, is there anyway to remove the embedded Macro without opening the file? I attached here is a automated error generated by Microsoft. __________________ 愿：世界和平

17th Apr 2008, 01:26 AM	#2 (permalink)
belikethat I'm a regular Join Date: 25 Apr 2006 Posts: 496 Reputation: 58 Rep Power: 3	probably file corrupted, try using openoffice to open and me no see the error u mentioned.. btw marco could be dangerous __________________ Control Panel Settings & Options Edit Signature

18th Apr 2008, 01:22 AM	#4 (permalink)
Adrian Wong Da Boss Join Date: 10 Oct 2002 Location: In front of my BenQ Joybook 7000 notebook! Posts: 29,426 Reputation: 2830 Rep Power: 63	You might also want to check if you have installed the Korean font. Even if the file is supposed to be in English, he/she may have accidentally put in a single Korean letter or something like that. __________________ Dr. Adrian Wong Tech ARP \| Blog @ Tech ARP \| The Free Trade Zone DYKT : The only offshore account I have is at the sand bank? Keep Tech ARP free! Visit our sponsors! We need PROGRAMMERS and TECHNICAL WRITERS! Contact us if you are a hot shot programmer or technical writer! My items for sale : 50x SD Card \| Memory Stick PRO \| Cyclone Energy Saver \| Seiko SS watch \| Tiger/Carlsberg beer jugs \| Travel Speakers \| Motorola V600 \| Nokia N90 SOLD! \| New Lowepro Mini Trekker AW Other items for sale @ the FTZ : Zalman CNPS9500 LED @ $20 \| Zalman CNPS7700 Cu @ $20 \| Zalman CNPS7000 Cu @ $20 \| Swarovski bracelet watches \| Dell 17" LCD \| Hi-Fi speakers \| English DIVX movies \| HP LaserJet toners! \| Office chairs

27th Apr 2008, 01:25 AM	#5 (permalink)
alyy8128 Just Started Join Date: 22 Jan 2006 Location: Senai Johor Posts: 64 Reputation: 12 Rep Power: 0	Anyway, thanks all for your kind suggestion. They problem is still there, but I had quickly copy the data out from the worksheet to another New Created file (when i can open that file). So i still can continue my job without open that stupid file again. __________________ 愿：世界和平

28th Apr 2008, 08:07 PM	#6 (permalink)
alyy8128 Just Started Join Date: 22 Jan 2006 Location: Senai Johor Posts: 64 Reputation: 12 Rep Power: 0	I think is that company include some "security" features on their file. They just sent me another file, but totally cannot view what is that. Then, after i request to re-send, they just apologise that they forgot to remove some kind of encryption on it. __________________ 愿：世界和平

17th Apr 2008, 09:17 AM	#3 (permalink)
Zenphic Active Join Date: 23 Apr 2006 Location: Quebec, Canada Posts: 694 Reputation: 176 Rep Power: 4	Yeah, it's possible that it's corrupt. Try opening it via File > Open then next to the button Open, there a little arrow, click it and choose "Open and Repair". This is on Office 2003, not sure if Office 2000 has this. You might want to give OpenOffice a try also. You might also want to try what's written under "Fixing Corrupt Files" in this page: Excel 2000 Problems