Why won't Excel let me copy and paste my concantenate formula now

[Jennifer]

I have been using the concantenate for names just fine for months. All of
the sudden, I can't copy and paste the formula. It is just pastes the name
and not the formulas. Any ideas why this would just start happening?

Hi

Maybe your calculation is set to manual (Tools/Options/Calculation) so it
looks like it's not copying the formula. Or maybe your references in the
formula are absolute (with $ signs) rather than being relative.

Andy.

"Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
news:68ED93AE-83AB-4B32-95EA-C3A02FABC4D4@microsoft.com...
>I have been using the concantenate for names just fine for months. All of
> the sudden, I can't copy and paste the formula. It is just pastes the
> name
> and not the formulas. Any ideas why this would just start happening?

[Jennifer]

That solved my problem. Thank you so much!!

"Andy" wrote:

> Hi
>
> Maybe your calculation is set to manual (Tools/Options/Calculation) so it
> looks like it's not copying the formula. Or maybe your references in the
> formula are absolute (with $ signs) rather than being relative.
>
> Andy.
>
> "Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
> news:68ED93AE-83AB-4B32-95EA-C3A02FABC4D4@microsoft.com...
> >I have been using the concantenate for names just fine for months. All of
> > the sudden, I can't copy and paste the formula. It is just pastes the
> > name
> > and not the formulas. Any ideas why this would just start happening?
>
>
>

It's a pleasure! Thanks for the feedback.

"Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
news:34D51263-523F-4E48-B631-FE11DED5CD8C@microsoft.com...
> That solved my problem. Thank you so much!!
>
> "Andy" wrote:
>
>> Hi
>>
>> Maybe your calculation is set to manual (Tools/Options/Calculation) so it
>> looks like it's not copying the formula. Or maybe your references in the
>> formula are absolute (with $ signs) rather than being relative.
>>
>> Andy.
>>
>> "Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
>> news:68ED93AE-83AB-4B32-95EA-C3A02FABC4D4@microsoft.com...
>> >I have been using the concantenate for names just fine for months. All
>> >of
>> > the sudden, I can't copy and paste the formula. It is just pastes the
>> > name
>> > and not the formulas. Any ideas why this would just start happening?
>>
>>
>>