Was merrily working on a file, saving it, etc.. Now when
I try to open it, it gets about half way (as indicated
from the blue bar) and just sits there. When I go to the
Windows Task Manager the status is "Not Repsonding".

The file is indeed large (50mb), and has quite a few
calculations involved, but I have larger that I am able to
open... If I could just get it open once, I can shear
some of the data, to avoid this going forward, but I can't
even open it...

HELP?!

What version Excel?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"JEFF" wrote in message
...
Was merrily working on a file, saving it, etc.. Now when
I try to open it, it gets about half way (as indicated
from the blue bar) and just sits there. When I go to the
Windows Task Manager the status is "Not Repsonding".

The file is indeed large (50mb), and has quite a few
calculations involved, but I have larger that I am able to
open... If I could just get it open once, I can shear
some of the data, to avoid this going forward, but I can't
even open it...

HELP?!

2000 SR-1 Professional .... Thanks
-----Original Message-----
What version Excel?

--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------
------------------
It's easier to beg forgiveness than ask
permission :-)
----------------------------------------------------------
------------------

"JEFF" wrote in
message
...
Was merrily working on a file, saving it, etc.. Now
when
I try to open it, it gets about half way (as indicated
from the blue bar) and just sits there. When I go to
the
Windows Task Manager the status is "Not Repsonding".

The file is indeed large (50mb), and has quite a few
calculations involved, but I have larger that I am able
to
open... If I could just get it open once, I can shear
some of the data, to avoid this going forward, but I
can't
even open it...

HELP?!


.

Firstly, can anyone else open the file or is it just you that has the
problem?
If just you then it's possible it's your *.xlb file (Toolbar customisation
file) is beginning to corrupt, although a 50MB workbook in 2000 probably
isn't good anyway (See Charles Williams' site as to Excel'a internal memory
limits)

http://www.decisionmodels.com/memlimitsc.htm

You can try deleting your *.xlb and then opening the file. (You will lose
any toolbar customisations)

You can try asking someone with Excel 2002 or 2003 to open the file (Agains
see Charles' site as to why they will have more luck than you). Besides the
memory improvements they also have 'open and repair' options

You can try opening it in OpenOffice which is a free officesuite available
from

www.openoffice.org

though it's a 70MB download. It can often open excel files that even Excel
can't.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"JEFF" wrote in message
...
2000 SR-1 Professional .... Thanks
-----Original Message-----
What version Excel?

--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------
------------------
It's easier to beg forgiveness than ask
permission :-)
----------------------------------------------------------
------------------

"JEFF" wrote in
message
...
Was merrily working on a file, saving it, etc.. Now
when
I try to open it, it gets about half way (as indicated
from the blue bar) and just sits there. When I go to
the
Windows Task Manager the status is "Not Repsonding".

The file is indeed large (50mb), and has quite a few
calculations involved, but I have larger that I am able
to
open... If I could just get it open once, I can shear
some of the data, to avoid this going forward, but I
can't
even open it...

HELP?!


.

Have you tried shutting off the Automatic calculation (Tools-Options-Calculation and
check "Manual") before opening the workbook?


--
Regards;
Rob
------------------------------------------------------------------------
"JEFF" wrote in message
...
Was merrily working on a file, saving it, etc.. Now when
I try to open it, it gets about half way (as indicated
from the blue bar) and just sits there. When I go to the
Windows Task Manager the status is "Not Repsonding".

The file is indeed large (50mb), and has quite a few
calculations involved, but I have larger that I am able to
open... If I could just get it open once, I can shear
some of the data, to avoid this going forward, but I can't
even open it...

HELP?!

Thanks for the repy: Yes, unsuccessfully

"RWN" wrote:

Have you tried shutting off the Automatic calculation (Tools-Options-Calculation and
check "Manual") before opening the workbook?


--
Regards;
Rob
------------------------------------------------------------------------
"JEFF" wrote in message
...
Was merrily working on a file, saving it, etc.. Now when
I try to open it, it gets about half way (as indicated
from the blue bar) and just sits there. When I go to the
Windows Task Manager the status is "Not Repsonding".

The file is indeed large (50mb), and has quite a few
calculations involved, but I have larger that I am able to
open... If I could just get it open once, I can shear
some of the data, to avoid this going forward, but I can't
even open it...

HELP?!

Thanks for the reply:

1. I'm here alone, but have a PC and laptop both trying to open it (resides
on network)

2. Tried the *.xlb file fix, no luck

3. I think I will try your websites.... Thanks.

"Ken Wright" wrote:

Firstly, can anyone else open the file or is it just you that has the
problem?
If just you then it's possible it's your *.xlb file (Toolbar customisation
file) is beginning to corrupt, although a 50MB workbook in 2000 probably
isn't good anyway (See Charles Williams' site as to Excel'a internal memory
limits)

http://www.decisionmodels.com/memlimitsc.htm

You can try deleting your *.xlb and then opening the file. (You will lose
any toolbar customisations)

You can try asking someone with Excel 2002 or 2003 to open the file (Agains
see Charles' site as to why they will have more luck than you). Besides the
memory improvements they also have 'open and repair' options

You can try opening it in OpenOffice which is a free officesuite available
from

www.openoffice.org

though it's a 70MB download. It can often open excel files that even Excel
can't.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"JEFF" wrote in message
...
2000 SR-1 Professional .... Thanks
-----Original Message-----
What version Excel?

--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------
------------------
It's easier to beg forgiveness than ask
permission :-)
----------------------------------------------------------
------------------

"JEFF" wrote in
message
...
Was merrily working on a file, saving it, etc.. Now
when
I try to open it, it gets about half way (as indicated
from the blue bar) and just sits there. When I go to
the
Windows Task Manager the status is "Not Repsonding".

The file is indeed large (50mb), and has quite a few
calculations involved, but I have larger that I am able
to
open... If I could just get it open once, I can shear
some of the data, to avoid this going forward, but I
can't
even open it...

HELP?!


.

"..(resides on network).."
Have you tried copying it to you HD and opening it?

--
Regards;
Rob
------------------------------------------------------------------------
<snip

Thanks, but again no luck.....

"RWN" wrote:

"..(resides on network).."
Have you tried copying it to you HD and opening it?

--
Regards;
Rob
------------------------------------------------------------------------
<snip

Geez, I'm batting 1000 here!.
It's beyond me as both the suggestions I gave have worked for me in the past, albeit my
files weren't that big (mind you, I don't profess to being an expert).

Have you let it "sit" for an extended period of time?
I had a similar occurrence this last week (file opening to a point then task mgr = "Not
Responding).
I kept ending the task after about a minute or so. Then, by fluke, when I tried opening
it again I got called away for about 30 minutes and when I returned it had finished up.
Turned out that I had a very "piggish" command ("=SUM(1/COUNTIF(A2:A23896,A2:A23896))")
that I'd forgotten about on one of the sheets. I closed the book and set the calc mode to
Manual and it opened no problem.
When you find it I'd be interested to know what it was ("forewarned is forearmed").

--
Regards;
Rob
------------------------------------------------------------------------
"JEFF" wrote in message
...
Thanks, but again no luck.....

"RWN" wrote:

"..(resides on network).."
Have you tried copying it to you HD and opening it?

--
Regards;
Rob
------------------------------------------------------------------------
<snip

I appreciate the effort! I'm going to let the pig sit and try to open
over-night ... Thanks again.

"RWN" wrote:

Geez, I'm batting 1000 here!.
It's beyond me as both the suggestions I gave have worked for me in the past, albeit my
files weren't that big (mind you, I don't profess to being an expert).

Have you let it "sit" for an extended period of time?
I had a similar occurrence this last week (file opening to a point then task mgr = "Not
Responding).
I kept ending the task after about a minute or so. Then, by fluke, when I tried opening
it again I got called away for about 30 minutes and when I returned it had finished up.
Turned out that I had a very "piggish" command ("=SUM(1/COUNTIF(A2:A23896,A2:A23896))")
that I'd forgotten about on one of the sheets. I closed the book and set the calc mode to
Manual and it opened no problem.
When you find it I'd be interested to know what it was ("forewarned is forearmed").

--
Regards;
Rob
------------------------------------------------------------------------
"JEFF" wrote in message
...
Thanks, but again no luck.....

"RWN" wrote:

"..(resides on network).."
Have you tried copying it to you HD and opening it?

--
Regards;
Rob
------------------------------------------------------------------------
<snip

Don't know how sensitive your data is, but if you zip a copy of the file,
how big is the zip file?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"JEFF" wrote in message
...
Thanks for the repy: Yes, unsuccessfully

"RWN" wrote:

Have you tried shutting off the Automatic calculation
(Tools-Options-Calculation and
check "Manual") before opening the workbook?


--
Regards;
Rob
------------------------------------------------------------------------
"JEFF" wrote in message
...
Was merrily working on a file, saving it, etc.. Now when
I try to open it, it gets about half way (as indicated
from the blue bar) and just sits there. When I go to the
Windows Task Manager the status is "Not Repsonding".

The file is indeed large (50mb), and has quite a few
calculations involved, but I have larger that I am able to
open... If I could just get it open once, I can shear
some of the data, to avoid this going forward, but I can't
even open it...

HELP?!

It goes from 53,920 KB to 52,142 (so much for packing)

"Ken Wright" wrote:

Don't know how sensitive your data is, but if you zip a copy of the file,
how big is the zip file?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"JEFF" wrote in message
...
Thanks for the repy: Yes, unsuccessfully

"RWN" wrote:

Have you tried shutting off the Automatic calculation
(Tools-Options-Calculation and
check "Manual") before opening the workbook?


--
Regards;
Rob
------------------------------------------------------------------------
"JEFF" wrote in message
...
Was merrily working on a file, saving it, etc.. Now when
I try to open it, it gets about half way (as indicated
from the blue bar) and just sits there. When I go to the
Windows Task Manager the status is "Not Repsonding".

The file is indeed large (50mb), and has quite a few
calculations involved, but I have larger that I am able to
open... If I could just get it open once, I can shear
some of the data, to avoid this going forward, but I can't
even open it...

HELP?!

Something's wrong. I'd expect it be circa 10% of that, unless you have it
full of bitmaps or something like that. You didn't have Winzip set to no
compression or something did you?

Where I was heading was that if you could get down to say a 10MB file or
less and were OK to email it to me, then I'd have a go at recovering it and
send it back for you.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"JEFF" wrote in message
...
It goes from 53,920 KB to 52,142 (so much for packing)

"Ken Wright" wrote:

Don't know how sensitive your data is, but if you zip a copy of the
file,
how big is the zip file?

<snip

Me too -- everything else I Zip gets compacted. For example, I have a very
similar workbook that I was able to reduce fom 54MB to 9MB.... I'm out of
ideas, you?

Thanks

"Ken Wright" wrote:

Something's wrong. I'd expect it be circa 10% of that, unless you have it
full of bitmaps or something like that. You didn't have Winzip set to no
compression or something did you?

Where I was heading was that if you could get down to say a 10MB file or
less and were OK to email it to me, then I'd have a go at recovering it and
send it back for you.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"JEFF" wrote in message
...
It goes from 53,920 KB to 52,142 (so much for packing)

"Ken Wright" wrote:

Don't know how sensitive your data is, but if you zip a copy of the
file,
how big is the zip file?

<snip

One more note: the workbook is password protected -- not sure if this
matters as it hasn't in the past.....

"JEFF" wrote:

Me too -- everything else I Zip gets compacted. For example, I have a very
similar workbook that I was able to reduce fom 54MB to 9MB.... I'm out of
ideas, you?

Thanks

"Ken Wright" wrote:

Something's wrong. I'd expect it be circa 10% of that, unless you have it
full of bitmaps or something like that. You didn't have Winzip set to no
compression or something did you?

Where I was heading was that if you could get down to say a 10MB file or
less and were OK to email it to me, then I'd have a go at recovering it and
send it back for you.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"JEFF" wrote in message
...
It goes from 53,920 KB to 52,142 (so much for packing)

"Ken Wright" wrote:

Don't know how sensitive your data is, but if you zip a copy of the
file,
how big is the zip file?

<snip

Did you try the OpenOffice option?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
<snip

Success at last! After going to the website you recommened (below), the
light bulb went on and I found someone with Excel 2003 and voila!

Thanks for all the help


http://www.decisionmodels.com/memlimitsc.htm


the Found someone with Excel 2003 and they were able to open it.

"Ken Wright" wrote:

Did you try the OpenOffice option?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
<snip

Good stuff - Now would be a good time to make a backup copy though :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"JEFF" wrote in message
...
Success at last! After going to the website you recommened (below), the
light bulb went on and I found someone with Excel 2003 and voila!

Thanks for all the help


http://www.decisionmodels.com/memlimitsc.htm


the Found someone with Excel 2003 and they were able to open it.

"Ken Wright" wrote:

Did you try the OpenOffice option?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)

--------------------------------------------------------------------------
--
<snip