Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why won't Excel let me copy and paste my concantenate formula now
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why won't Excel let me copy and paste my concantenate formula now
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" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why won't Excel let me copy and paste my concantenate formula
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" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why won't Excel let me copy and paste my concantenate formula
It's a pleasure! Thanks for the feedback.
"Jennifer" wrote in message ... 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" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Copy and paste special - values into new excel file | Excel Discussion (Misc queries) | |||
copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) |