Excel 2000, Duplicate Information

[Pitseleh]

This is rather vague, but anyone have information about a problem wherein certain cells of information typed in one worksheet appear in many other worksheets? The problem occurred for a user and I don't know what they were specificaly doing aside from typing in info.

It's a single row of information that's duplicated; however, not EVERY cell in the row is duplicated...only the cells that contain unique information in the worksheet are duplicated across the worksheets (i.e., there are 3 or 4 columns that contain the same info in all cells, such as client name, and this same format is applied on all worksheets).

The workbook has about 40 sheets, and 14 sheets are affected by the problem. There are no macros in the workbook, though there are many calculations on one sheet that reference information on other worksheets.

Thanks.

[LegareColeman]

What you are describing can happen if you have more than one sheet selected when you type data. For example, if you hold down the Ctrl key and click on several of the worksheet tabs, all of those sheets will become selected. Then anything you type on the active sheet will also appear in the same cells it all of the other selected sheets. Also, if you hold down the shift key and click on a sheet tab other that the active sheet, then all sheets between the active sheet and the one clicked on will be selected (this is sounds like what might have happened). Again, anything typed in the active sheet will appear in all selected sheets.

[Pitseleh]

Wow. How did I not know that? Thanks for the education!

[LegareColeman]

If we all knew everything, then there would be no need for places like this! <img src=/S/smile.gif border=0 width=15 height=15>

[gwhitfield]

Fair comment! I like it.