| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel automatically insert current date in a cell? | Excel Worksheet Functions | |||
| Data in Excel is not wrapping within cell consistently | Excel Discussion (Misc queries) | |||
| How to sort/update large excel db | Excel Discussion (Misc queries) | |||
| enter data in cell then run macro automatically | Excel Discussion (Misc queries) | |||
| Enter Data Into Another Excel File Automatically | Excel Worksheet Functions | |||
Linear Mode
