excel doing some weired stuff

[Jamal]

Hi, I didn't know how to ask the question so, I will have to give you the
story about it.

I have a worksheet that has two tabs. First tab names 2008 and second one
named 2009

When I enter a title in A1 on 2009 tab it is automaticaly showed on 2008 tab
cell A1. My title is like "year end totals"

Why this is happening? I don't know but I double checked to see if there a
macros or reference functions. There is no command that tells it to do that .

Please help me , this is driving me crazy.

 

[Ron de Bruin]

Hi Jamal

Do you see [group] in the title bar after the file name?

I think both sheets are selected, all the changes you make are for both tabs.
Right click on a sheet tab and choose ungroup sheets

 

[Dave Peterson]

Are both sheet selected/Grouped?

Look for [Group] in the title bar.

If yes, then rightclick on one of the worksheet tabs and choose Ungroup Sheets.

If no, look at the "receiving" cell and see if you have a formula like:
=if('2009'!a1="","",'2009'!a1)

And if you don't want that, just delete the formula.

===
And you're positive you checked for worksheet/workbook event macros, too???

 

[Jamal]

Thankyou for the response.

Are both sheet selected/Grouped?

Look for [Group] in the title bar.

If yes, then rightclick on one of the worksheet tabs and choose Ungroup Sheets.

If no, look at the "receiving" cell and see if you have a formula like:
=if('2009'!a1="","",'2009'!a1)

And if you don't want that, just delete the formula.

===
And you're positive you checked for worksheet/workbook event macros, too???

Hi, I didn't know how to ask the question so, I will have to give you the
story about it.

I have a worksheet that has two tabs. First tab names 2008 and second one
named 2009

When I enter a title in A1 on 2009 tab it is automaticaly showed on 2008 tab
cell A1. My title is like "year end totals"

Why this is happening? I don't know but I double checked to see if there a
macros or reference functions. There is no command that tells it to do that .

Please help me , this is driving me crazy.

 

[Jamal]

Thankyou for the response.

Hi Jamal

Do you see [group] in the title bar after the file name?

I think both sheets are selected, all the changes you make are for both tabs.
Right click on a sheet tab and choose ungroup sheets


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

Hi, I didn't know how to ask the question so, I will have to give you the
story about it.

I have a worksheet that has two tabs. First tab names 2008 and second one
named 2009

When I enter a title in A1 on 2009 tab it is automaticaly showed on 2008 tab
cell A1. My title is like "year end totals"

Why this is happening? I don't know but I double checked to see if there a
macros or reference functions. There is no command that tells it to do that .

Please help me , this is driving me crazy.