View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default Stop excel from copying data from one sheet to another

Sounds like you're in group mode. Right-click a sheet tab and select Ungroup
Sheets, and this behavior should stop.

"Imajica" wrote:

I have a workbook (actually 75 workbooks) and it has ten worksheets. In each
sheet I have a subtotal at the end of each row (34 in all) and at the bottom
of each column (25 in all) I have copied this formula onto each sheet. The
problem I am having is that in the blank cells (of any worksheet), I enter a
number and it is being transposed onto the other nine worksheets. I have no
formulas in any of the cells or the other worksheets telling it to transfer
the information. What I need to know is, how do i stop it from copying
information from one sheet to the other without having to redo my workbooks?