I have a 'summary' tab and a 'detailed' tab.

Cell C16 on both seem to be linked somehow.  When I change C16 on the 
'detailed' tab to be the text I need, it puts that same text in cell C16 on 
the summary tab... which I need to be a formula etc.

How can I un-link these cells from tab to tab

Cell C16 on your summary tab is most likely a formula something like...

='Detailed'!C16

remove/delete that formula and the cell will no longer be linked.
-- 
HTH...

Jim Thomlinson


"Michelle" wrote:

> I have a 'summary' tab and a 'detailed' tab.
> 
> Cell C16 on both seem to be linked somehow.  When I change C16 on the 
> 'detailed' tab to be the text I need, it puts that same text in cell C16 on 
> the summary tab... which I need to be a formula etc.
> 
> How can I un-link these cells from tab to tab

Michelle,

Note the terminology, WORKSHEET and not TAB. A TAB is the part of a 
worksheet that holds the name and provides some other functionality.

Select C16 on the summary worksheet and look in the formula bar, what's 
there? does it say something like

=Sheet1!$C$16

Where Sheet1 is the name of your Detail worksheet. If so delete the formula 
and the link is broken.

I don't understand
which I need to be a formula etc.

-- 
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that 
introduces the fewest assumptions while still sufficiently answering the 
question.


"Michelle" wrote:

> I have a 'summary' tab and a 'detailed' tab.
> 
> Cell C16 on both seem to be linked somehow.  When I change C16 on the 
> 'detailed' tab to be the text I need, it puts that same text in cell C16 on 
> the summary tab... which I need to be a formula etc.
> 
> How can I un-link these cells from tab to tab