Can't Open Saved File

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in
message
>news:[email protected]...
>> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in
> message
> >news:[email protected]...
> >> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in
> > message
> > >news:[email protected]...
> > >> 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>

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


--
Regards;
Rob
------------------------------------------------------------------------
"JEFF" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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?!
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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" <[email protected]> wrote in message
news:[email protected]...
> 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> >