Tabs seem to be linked somehow

  • Thread starter Thread starter Eric_NY
  • Start date Start date
E

Eric_NY

I'm using Excel 2003 to update a spreadsheet that I've received from someone
else via email. The sheet has two tabs.

Something funny is happening - sometimes when I update one tab, the same
data sometimes appears in the corresponding position in the other tab. It's
weird.

Any idea what's happening??

Thanks.
 
sorry but i have to ask you one silly question (please don't mind), you sure
that there are no reference of the cells in second tab from the first tab? :)

A1 in Sheet2 has a formula
=Sheet1!A1

-kc
*Click YES if this helps
 
No, it's a good question. But no, there are no references to other cells. All
literals.

The tas were linked in another way. I inserted a row in tab 1, and Excel
also inserted a row in tab 2. I deleted the extra row in tab 2, and Excel
deleted the row in tab 1.

(Of course, I have just played with the same sheet - after saving, then
exiting Excel and reopening it - and can't replicate the problem, so maybe it
was a termporary problem.)
 
Sounds like you had both sheets selected.........grouped.

When sheets are grouped whatever you do to the active sheet will be done to
all.

Test this.............select Sheet1 then CTRL + click on Sheet2.

You should see [Group] in the Title Bar next to the Filename


Gord Dibben MS Excel MVP
 
Back
Top