Excel self replication - help !

Hi

I have a mojor problem, a 14 Mb workbook with about 10 sheets inside, with
various lookups, validation, etc but NO MACROS. When I try and delete or
insert a column, Excel opens a copy of the workbook and another Excel sheet
(blank). The whole computer locks up and Excel effectively crashes by 'Not
responding'.

Any advice greatly appreciated.

Thanks in advance . . . . Stuart

Maybe you have macros where you didn't look.

Debra Dalgleish has nice instructions for getting rid of macros at:
http://www.contextures.com/xlfaqMac.html#NoMacros

Maybe it'll help you find something overlooked.

"Gniff!" wrote:
>
> Hi
>
> I have a mojor problem, a 14 Mb workbook with about 10 sheets inside, with
> various lookups, validation, etc but NO MACROS. When I try and delete or
> insert a column, Excel opens a copy of the workbook and another Excel sheet
> (blank). The whole computer locks up and Excel effectively crashes by 'Not
> responding'.
>
> Any advice greatly appreciated.
>
> Thanks in advance . . . . Stuart

--

Dave Peterson

Thx

I'll give it a go - there shouldn't be any Macros, I've never tried to write
one !!

Stuart

"Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
news:427E8293.BCE1675D@netscapeXSPAM.com...
> Maybe you have macros where you didn't look.
>
> Debra Dalgleish has nice instructions for getting rid of macros at:
> http://www.contextures.com/xlfaqMac.html#NoMacros
>
> Maybe it'll help you find something overlooked.
>
> "Gniff!" wrote:
>>
>> Hi
>>
>> I have a mojor problem, a 14 Mb workbook with about 10 sheets inside,
>> with
>> various lookups, validation, etc but NO MACROS. When I try and delete or
>> insert a column, Excel opens a copy of the workbook and another Excel
>> sheet
>> (blank). The whole computer locks up and Excel effectively crashes by
>> 'Not
>> responding'.
>>
>> Any advice greatly appreciated.
>>
>> Thanks in advance . . . . Stuart
>
> --
>
> Dave Peterson

gave it a go and no difference :o(

I also tried rebuilding the calculation chain (search and replace '=') which
only served to increase the file size - aagghh!

any other ideas out there ??

thx in adv . . . stuart

"Stuart" <stuartdavidson@ecosse.net> wrote in message
news:ubenCaBVFHA.2172@tk2msftngp13.phx.gbl...
> Thx
>
> I'll give it a go - there shouldn't be any Macros, I've never tried to
> write one !!
>
> Stuart
>
> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
> news:427E8293.BCE1675D@netscapeXSPAM.com...
>> Maybe you have macros where you didn't look.
>>
>> Debra Dalgleish has nice instructions for getting rid of macros at:
>> http://www.contextures.com/xlfaqMac.html#NoMacros
>>
>> Maybe it'll help you find something overlooked.
>>
>> "Gniff!" wrote:
>>>
>>> Hi
>>>
>>> I have a mojor problem, a 14 Mb workbook with about 10 sheets inside,
>>> with
>>> various lookups, validation, etc but NO MACROS. When I try and delete
>>> or
>>> insert a column, Excel opens a copy of the workbook and another Excel
>>> sheet
>>> (blank). The whole computer locks up and Excel effectively crashes by
>>> 'Not
>>> responding'.
>>>
>>> Any advice greatly appreciated.
>>>
>>> Thanks in advance . . . . Stuart
>>
>> --
>>
>> Dave Peterson
>
>

Try starting excel in safe mode.

Close excel
windows start button|run
excel /safe

Then File|open your workbook.

Do you get the same results? If no, then maybe it's a macro in another
workbook.

Chip Pearson has some notes on how to diagnose startup errors at:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes at:
http://www.jkp-ads.com/Articles/StartupProblems.htm



Stuart wrote:
>
> gave it a go and no difference :o(
>
> I also tried rebuilding the calculation chain (search and replace '=') which
> only served to increase the file size - aagghh!
>
> any other ideas out there ??
>
> thx in adv . . . stuart
>
> "Stuart" <stuartdavidson@ecosse.net> wrote in message
> news:ubenCaBVFHA.2172@tk2msftngp13.phx.gbl...
> > Thx
> >
> > I'll give it a go - there shouldn't be any Macros, I've never tried to
> > write one !!
> >
> > Stuart
> >
> > "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
> > news:427E8293.BCE1675D@netscapeXSPAM.com...
> >> Maybe you have macros where you didn't look.
> >>
> >> Debra Dalgleish has nice instructions for getting rid of macros at:
> >> http://www.contextures.com/xlfaqMac.html#NoMacros
> >>
> >> Maybe it'll help you find something overlooked.
> >>
> >> "Gniff!" wrote:
> >>>
> >>> Hi
> >>>
> >>> I have a mojor problem, a 14 Mb workbook with about 10 sheets inside,
> >>> with
> >>> various lookups, validation, etc but NO MACROS. When I try and delete
> >>> or
> >>> insert a column, Excel opens a copy of the workbook and another Excel
> >>> sheet
> >>> (blank). The whole computer locks up and Excel effectively crashes by
> >>> 'Not
> >>> responding'.
> >>>
> >>> Any advice greatly appreciated.
> >>>
> >>> Thanks in advance . . . . Stuart
> >>
> >> --
> >>
> >> Dave Peterson
> >
> >

--

Dave Peterson

gave it a go - no difference, though there seems to be some latent sheets
from SPSS (the data source). I'm going to have to start from scratch !!

thx for all the advice. . . . .Gniff!


"Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
news:427E8E8A.DB843F75@netscapeXSPAM.com...
> Try starting excel in safe mode.
>
> Close excel
> windows start button|run
> excel /safe
>
> Then File|open your workbook.
>
> Do you get the same results? If no, then maybe it's a macro in another
> workbook.
>
> Chip Pearson has some notes on how to diagnose startup errors at:
> http://www.cpearson.com/excel/StartupErrors.htm
>
> And Jan Karel Pieterse has more notes at:
> http://www.jkp-ads.com/Articles/StartupProblems.htm
>
>
>
> Stuart wrote:
>>
>> gave it a go and no difference :o(
>>
>> I also tried rebuilding the calculation chain (search and replace '=')
>> which
>> only served to increase the file size - aagghh!
>>
>> any other ideas out there ??
>>
>> thx in adv . . . stuart
>>
>> "Stuart" <stuartdavidson@ecosse.net> wrote in message
>> news:ubenCaBVFHA.2172@tk2msftngp13.phx.gbl...
>> > Thx
>> >
>> > I'll give it a go - there shouldn't be any Macros, I've never tried to
>> > write one !!
>> >
>> > Stuart
>> >
>> > "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
>> > news:427E8293.BCE1675D@netscapeXSPAM.com...
>> >> Maybe you have macros where you didn't look.
>> >>
>> >> Debra Dalgleish has nice instructions for getting rid of macros at:
>> >> http://www.contextures.com/xlfaqMac.html#NoMacros
>> >>
>> >> Maybe it'll help you find something overlooked.
>> >>
>> >> "Gniff!" wrote:
>> >>>
>> >>> Hi
>> >>>
>> >>> I have a mojor problem, a 14 Mb workbook with about 10 sheets inside,
>> >>> with
>> >>> various lookups, validation, etc but NO MACROS. When I try and
>> >>> delete
>> >>> or
>> >>> insert a column, Excel opens a copy of the workbook and another Excel
>> >>> sheet
>> >>> (blank). The whole computer locks up and Excel effectively crashes
>> >>> by
>> >>> 'Not
>> >>> responding'.
>> >>>
>> >>> Any advice greatly appreciated.
>> >>>
>> >>> Thanks in advance . . . . Stuart
>> >>
>> >> --
>> >>
>> >> Dave Peterson
>> >
>> >
>
> --
>
> Dave Peterson