WHAT HAPPENED!!!!

thanks - good advice.


Bob Greenblatt wrote:
> On 12/7/06 9:57 AM, in article
> 1165503467.744255.95870 RemoveThis @j44g2000cwa.googlegroups.com, "vonderay"
> <vonderay RemoveThis @yahoo.com> wrote:
>
> > what i dont understand is that i saved the NEW file several times and
> > it reverted to an old file? how did it do this? how does the os know
> > to go to "which" file???
> >
> > little_creature wrote:
> >> Steps hat can help solve doccument corruption:
> >>
> >> *I would check or temporary disble links to other files
> >> (if there ever been any there might be some parts still even you cannot see
> >> it, the you should use utility to remove all bits)
> >> http://www.bmsltd.ie/MVP/Default.htm
> >>
> >> * You might try to remove all macros included in woorkbook (if needed
> >> afterwards you can copy it from older version of the corrupted file) (check
> >> both Workbook module and sheet modules.)
> >>
> >> *I woud also check all formulas
> >>
> >> *You might search for "bad" characters as well - if you push
> >> CTRl+shift+arrows should put you on your last record in column/row, if not
> >> there§s somewhere bad character - then I would copy all your data by bits
> >> into new workbook
> >>
> >> *might try to ShowSave the file in SYLK format
> >>
> >>
> >> On 7.12.2006 9:26, in article
> >> 1165479968.253635.12700 RemoveThis @j44g2000cwa.googlegroups.com, "vonderay"
> >> <vonderay RemoveThis @yahoo.com> wrote:
> >>
> >>> I save a model in excel - simple sums and totals financial model -
> >>> several times during the day and it crashed. now the latest version is
> >>> the one I save YESTERDAY!!!!! ARGH!!!! What happened??? how do I fix
> >>> this and recover my file!?!?!?!
> >>>
> >>>
> >>> thanks
> >>>
> >
> I can't tell you exactly how it happened, but when Excel saves a file, it
> first creates a new invisible copy with an internal file name. If the save
> is successful, it deletes the original copy, renames the new file from the
> internal name to the original name and makes it visible. If it crashed
> during this process I can see how the named copy might be the original file
> if it had not yet had a chance to delete and rename files. Create a backup
> when you save - do a save as (use the same name and location), click on
> options and check Always make backup.
>
> Are you saving to a network drive? If so, save it locally and then copy to
> the network when you are done.
>
> --
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom

Steps hat can help solve doccument corruption:

*I would check or temporary disble links to other files
(if there ever been any there might be some parts still even you cannot see
it, the you should use utility to remove all bits)
http://www.bmsltd.ie/MVP/Default.htm

* You might try to remove all macros included in woorkbook (if needed
afterwards you can copy it from older version of the corrupted file) (check
both Workbook module and sheet modules.)

*I woud also check all formulas

*You might search for "bad" characters as well - if you push
CTRl+shift+arrows should put you on your last record in column/row, if not
there§s somewhere bad character - then I would copy all your data by bits
into new workbook

*might try to ShowSave the file in SYLK format


On 7.12.2006 9:26, in article
1165479968.253635.12700.DeleteThis@j44g2000cwa.googlegroups.com, "vonderay"
<vonderay.DeleteThis@yahoo.com> wrote:

> I save a model in excel - simple sums and totals financial model -
> several times during the day and it crashed. now the latest version is
> the one I save YESTERDAY!!!!! ARGH!!!! What happened??? how do I fix
> this and recover my file!?!?!?!
>
>
> thanks
>

On 12/7/06 9:57 AM, in article
1165503467.744255.95870.TakeThisOut@j44g2000cwa.googlegroups.com, "vonderay"
<vonderay.TakeThisOut@yahoo.com> wrote:

> what i dont understand is that i saved the NEW file several times and
> it reverted to an old file? how did it do this? how does the os know
> to go to "which" file???
>
> little_creature wrote:
>> Steps hat can help solve doccument corruption:
>>
>> *I would check or temporary disble links to other files
>> (if there ever been any there might be some parts still even you cannot see
>> it, the you should use utility to remove all bits)
>> http://www.bmsltd.ie/MVP/Default.htm
>>
>> * You might try to remove all macros included in woorkbook (if needed
>> afterwards you can copy it from older version of the corrupted file) (check
>> both Workbook module and sheet modules.)
>>
>> *I woud also check all formulas
>>
>> *You might search for "bad" characters as well - if you push
>> CTRl+shift+arrows should put you on your last record in column/row, if not
>> there§s somewhere bad character - then I would copy all your data by bits
>> into new workbook
>>
>> *might try to ShowSave the file in SYLK format
>>
>>
>> On 7.12.2006 9:26, in article
>> 1165479968.253635.12700.TakeThisOut@j44g2000cwa.googlegroups.com, "vonderay"
>> <vonderay.TakeThisOut@yahoo.com> wrote:
>>
>>> I save a model in excel - simple sums and totals financial model -
>>> several times during the day and it crashed. now the latest version is
>>> the one I save YESTERDAY!!!!! ARGH!!!! What happened??? how do I fix
>>> this and recover my file!?!?!?!
>>>
>>>
>>> thanks
>>>
>
I can't tell you exactly how it happened, but when Excel saves a file, it
first creates a new invisible copy with an internal file name. If the save
is successful, it deletes the original copy, renames the new file from the
internal name to the original name and makes it visible. If it crashed
during this process I can see how the named copy might be the original file
if it had not yet had a chance to delete and rename files. Create a backup
when you save - do a save as (use the same name and location), click on
options and check Always make backup.

Are you saving to a network drive? If so, save it locally and then copy to
the network when you are done.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom