Excel automatically copied data from one cell to another...

[Jenny]

One of my excel spreadsheets has started automatically copying data from one
cell to another (or rather ROWS of data) without displaying any formula or
explanation for the information. It seems to insert it about 10 - 20 rows
apart, just one cell, and slips it in before one can notice it happening...
Can anyone suggest anything?

[Nick Hodge]

Jenny

Is this reproducible? If so I'll take a look at the file for you. Do you
get any warning when you open the workbook, asking to enable macros?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]HIS


"Jenny" <[email protected]> wrote in message
news:[email protected]...
> One of my excel spreadsheets has started automatically copying data from
> one
> cell to another (or rather ROWS of data) without displaying any formula or
> explanation for the information. It seems to insert it about 10 - 20 rows
> apart, just one cell, and slips it in before one can notice it
> happening...
> Can anyone suggest anything?

[Jenny]

Hi Nick. Well, it just seems to happen, so I'm not totally sure it is
reproducable on demand. No warnings on opening at all! Very strange.

"Nick Hodge" wrote:

> Jenny
>
> Is this reproducible? If so I'll take a look at the file for you. Do you
> get any warning when you open the workbook, asking to enable macros?
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> [email protected]HIS
>
>
> "Jenny" <[email protected]> wrote in message
> news:[email protected]...
> > One of my excel spreadsheets has started automatically copying data from
> > one
> > cell to another (or rather ROWS of data) without displaying any formula or
> > explanation for the information. It seems to insert it about 10 - 20 rows
> > apart, just one cell, and slips it in before one can notice it
> > happening...
> > Can anyone suggest anything?
>
>
>

[Nick Hodge]

Jenny

Your not starting with the numeric keypad with the numlock off are you? If
you switch off the numlock some of the keys turn to navigation keys... just
a thought

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]HIS


"Jenny" <[email protected]> wrote in message
news:[email protected]...
> Hi Nick. Well, it just seems to happen, so I'm not totally sure it is
> reproducable on demand. No warnings on opening at all! Very strange.
>
> "Nick Hodge" wrote:
>
>> Jenny
>>
>> Is this reproducible? If so I'll take a look at the file for you. Do
>> you
>> get any warning when you open the workbook, asking to enable macros?
>>
>> --
>> HTH
>> Nick Hodge
>> Microsoft MVP - Excel
>> Southampton, England
>> [email protected]HIS
>>
>>
>> "Jenny" <[email protected]> wrote in message
>> news:[email protected]...
>> > One of my excel spreadsheets has started automatically copying data
>> > from
>> > one
>> > cell to another (or rather ROWS of data) without displaying any formula
>> > or
>> > explanation for the information. It seems to insert it about 10 - 20
>> > rows
>> > apart, just one cell, and slips it in before one can notice it
>> > happening...
>> > Can anyone suggest anything?
>>
>>
>>

[Jenny]

Thanks Nick, but that's not it either... We've decided to ditch that
particular spreadsheet for now....

"Nick Hodge" wrote:

> Jenny
>
> Your not starting with the numeric keypad with the numlock off are you? If
> you switch off the numlock some of the keys turn to navigation keys... just
> a thought
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> [email protected]HIS
>
>
> "Jenny" <[email protected]> wrote in message
> news:[email protected]...
> > Hi Nick. Well, it just seems to happen, so I'm not totally sure it is
> > reproducable on demand. No warnings on opening at all! Very strange.
> >
> > "Nick Hodge" wrote:
> >
> >> Jenny
> >>
> >> Is this reproducible? If so I'll take a look at the file for you. Do
> >> you
> >> get any warning when you open the workbook, asking to enable macros?
> >>
> >> --
> >> HTH
> >> Nick Hodge
> >> Microsoft MVP - Excel
> >> Southampton, England
> >> [email protected]HIS
> >>
> >>
> >> "Jenny" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > One of my excel spreadsheets has started automatically copying data
> >> > from
> >> > one
> >> > cell to another (or rather ROWS of data) without displaying any formula
> >> > or
> >> > explanation for the information. It seems to insert it about 10 - 20
> >> > rows
> >> > apart, just one cell, and slips it in before one can notice it
> >> > happening...
> >> > Can anyone suggest anything?
> >>
> >>
> >>
>
>
>