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

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

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
HIS


"Jenny" wrote in message
...
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?

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
HIS


"Jenny" wrote in message
...
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

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
HIS


"Jenny" wrote in message
...
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
HIS


"Jenny" wrote in message
...
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?

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
HIS


"Jenny" wrote in message
...
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
HIS


"Jenny" wrote in message
...
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?