Can't Open Saved File

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" <anonymous@discussions.microsoft.com> wrote in message
news:0b0e01c51c20$fd221e50$a501280a@phx.gbl...
> 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?!

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" <anonymous@discussions.microsoft.com> wrote in
message
>news:0b0e01c51c20$fd221e50$a501280a@phx.gbl...
>> 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" <anonymous@discussions.microsoft.com> wrote in message
news:1b6401c51c25$29c7e120$a401280a@phx.gbl...
> 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" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:0b0e01c51c20$fd221e50$a501280a@phx.gbl...
> >> 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" <anonymous@discussions.microsoft.com> wrote in message
news:0b0e01c51c20$fd221e50$a501280a@phx.gbl...
> 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" <anonymous@discussions.microsoft.com> wrote in message
> news:0b0e01c51c20$fd221e50$a501280a@phx.gbl...
> > 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" <anonymous@discussions.microsoft.com> wrote in message
> news:1b6401c51c25$29c7e120$a401280a@phx.gbl...
> > 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" <anonymous@discussions.microsoft.com> wrote in
> > message
> > >news:0b0e01c51c20$fd221e50$a501280a@phx.gbl...
> > >> 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?!
> > >
> > >
> > >.
> > >
>
>
>

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" <JEFF@discussions.microsoft.com> wrote in message
news:E71C6427-28A4-4190-8D48-816F9ED5B0FE@microsoft.com...
> Thanks, but again no luck.....
>
> "RWN" wrote:
>
> > "..(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>
>
>
>

"..(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" <JEFF@discussions.microsoft.com> wrote in message
> news:E71C6427-28A4-4190-8D48-816F9ED5B0FE@microsoft.com...
> > 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" <JEFF@discussions.microsoft.com> wrote in message
news:3B3397FD-7B91-434F-969B-57E2FF32D704@microsoft.com...
> 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" <anonymous@discussions.microsoft.com> wrote in message
> > news:0b0e01c51c20$fd221e50$a501280a@phx.gbl...
> > > 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" <JEFF@discussions.microsoft.com> wrote in message
> news:3B3397FD-7B91-434F-969B-57E2FF32D704@microsoft.com...
> > 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" <anonymous@discussions.microsoft.com> wrote in message
> > > news:0b0e01c51c20$fd221e50$a501280a@phx.gbl...
> > > > 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" <JEFF@discussions.microsoft.com> wrote in message
news:543C4C15-FD89-47C5-82C3-C00878A0C35D@microsoft.com...
> 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" <JEFF@discussions.microsoft.com> wrote in message
> news:543C4C15-FD89-47C5-82C3-C00878A0C35D@microsoft.com...
> > 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" <JEFF@discussions.microsoft.com> wrote in message
> > news:543C4C15-FD89-47C5-82C3-C00878A0C35D@microsoft.com...
> > > 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" <JEFF@discussions.microsoft.com> wrote in message
news:801C83A4-1686-40F3-A450-C7599E618C6E@microsoft.com...
> 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>
> >
> >
> >