data entry problem after upgrade to Excel 07

[fankdale]

When I enter a value in a cell of one worksheet, it is automatically entered
in all of the worksheets in the same workbook, therefore corrupting data in
the other worksheets. Did not do this in previous 2000 version. Can I turn
this off?

 

[Rick Rothstein]

The only way I can think this would happen is if you have all the sheets
selected. If you did that manually, then just click the tab of any sheet
other than the active one and that should "break" the grouping. If you have
VB code that, when run, selects all the sheets, then you will need to add
code to force the selection to a single sheet before the code finishes
executing.

 

[Naz]

Hi

Are you sure that only shat sheet is selected.
Look at the worksheet tabs at the bottom, you know where it says Sheet1
sheet2 etc.

The only way i know this can happen is if you have more than one sheet
selected and you eneter data into one it will be changed on all selected
sheet.

Hope that helps


--

_______________________
Naz,
London
www.LivingWandsworth.co.uk