System Error : Catastrophic Failure in MS excel

[santoshsri]

Hello,

While opening an excel worksheet having macros , I get Error "System Error &H8000FFFF Catastrophic failure". When I click on Ok button , I see another message box as Microsoft Visual Basic : Out of memory , what does it mean ? My PC has 2 GB ram with 3 Ghz P4 processor. I don't see any memory shortage problem.
I can open and work on same worksheet successfully on other PCs of same configuration.
Can anyone please help me on troubleshooting this issue ?

[kadghar]

I recomend you to check your macro security options.
Open an empty Excel, and check

Tools>Options>S ecurity>Macro's Security

Set it to the lowest level so it wont report or block any macro.
Then close Excel, and then open it with your file.

If it refuses to open it again, i think you'll have to re-instal your office.

HTH