Excel - wont open file URGENT

[Preet]

Hi

I have a excel file, when I try to open it, the following messages pop
up

"Not enough memory"

and then:

"This program has performed an illegal operation"

Then you have to press "OK" and this will log you out of Excel

Can anyone help?

 

[Lady Layla]

Close all unneeded applications
Close Excel
Clean out Temp internet files, Temp directories, empty Recycle bin
Reboot
Open Excel, try opening file


: Hi
:
: I have a excel file, when I try to open it, the following messages pop
: up
:
: "Not enough memory"
:
: and then:
:
: "This program has performed an illegal operation"
:
: Then you have to press "OK" and this will log you out of Excel
:
: Can anyone help?
:
:
: ---
: Message posted
:

 

[Preet]

Lady it didnt work!!

I emptied everything and still to no avail

Any more suggesstions? It isnt just me 4 ppl have tried to open it with
the same problem.

Thanx

 

[Guest]

Preet
How big is the file? What version of Excel was it created in? What versions of Excel did you try and open it in

The following is an exceprt from a response by Norman Harker to a similar question
------------------------
Take a look at

Charles Williams
http://www.decisionmodels.com/memlimitsc.ht
------------------------

Good Luck
Mark Graesse
(e-mail address removed)


----- Preet > wrote: ----

Lady it didnt work!

I emptied everything and still to no avai

Any more suggesstions? It isnt just me 4 ppl have tried to open it wit
the same problem

Than

 

[Norman Harker]

Hi Preet!

If that fails, locate the Excel.xlb or Excel10.xlb file using Start >
Search > For Files and Folders. The xlb file should not be above
around 30kb and is usually much smaller. If it is bloated, there’s not
a lot that can be done with it but you should move it from it’s
current location.



The xlb file is where Excel stores your toolbar settings and any
special toolbars or buttons that you create. Don’t worry about the
absence of one of these files. When Excel completes the next
successful open and close, you will find it has created a new file.



As a precautionary measure. Once you have done any messing about with
your toolbars to get them how you want or to add new toolbars or
buttons, you should take a backup copy of it. If it bloats again, at
least you won't have to go back to scratch.



References to Slow Open / Save Problems:

Opening/Saving Bottlenecks (Charles Williams)

http://www.decisionmodels.com/optspeedd.htm#OpSave

Troubleshoot Startup Problems(MS):

http://support.microsoft.com/default.aspx?scid=kb;en-us;280504

Some tips on overcoming slow response (David McRitchie)

http://www.mvps.org/dmcritchie/excel/slowresp.htm


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Preet]

THANK YOU to everyone whom helped, Nornam your advise helped, also th
link to Charles Excel page allowed me to understand why this wa
occurring.

THANK YOU ONCE AGAIN I REALLY APPRECIATE IT