| 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) | |||
Hybrid Mode
