Cells act as if they are linked-link does not display in entry bar

[NatalieGS]

I'm having a problem. I have a workbook set up with two worksheets. The
worksheets are formatted the same way- they hold the same type of data.
However, one column acts as if the cells are linked between worksheets. For
example, if I complete cell D6 on the first worksheet, cell D6 on the 2nd
worksheet displays the same data.

But the entry bar shows the data for each worksheet, not a link.

Also, when I tried opening the Office menu to select "Prepare" and "Break
Links" I did not see "Break Links". So I'm very confused. Please help.

 

[Tony]

I'm having a problem.  I have a workbook set up with two worksheets.  The
worksheets are formatted the same way- they hold the same type of data.  
However, one column acts as if the cells are linked between worksheets.  For
example, if I complete cell D6 on the first worksheet, cell D6 on the 2nd
worksheet displays the same data.

But the entry bar shows the data for each worksheet, not a link.

Also, when I tried opening the Office menu to select "Prepare"  and "Break
Links" I did not see "Break Links".  So I'm very confused.  Please help.

Probably you selected two sheets the same time which will treat them
as one sheet when you do data entry. Try to select another sheet to
disgroup the sheet selection and go back to your sheet and then try it
again. HTH.