| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cut/Paste causes #REF
This has been bugging me for some time and I'm just wondering why it
happens. I have a simple formula in cell D16 that multiplies numbers in two other cells: =C16*A16 If I manually change the value in C16 the result in D16 is correct. If I copy/paste a value into C16, again, the result is corect. If I CUT/Paste a value into C16 then the formula changes to =#REF!*A16. Is there maybe a setting I have enabled that causes this or is it working as designed? If so, what is the logic behind the Cut/Paste that causes the #REF??? Thanks gang! This is no big deal, I'm just curious. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I repeat column headings on all of my sheets w/o cut/paste | Excel Discussion (Misc queries) | |||
| Automate cut/paste functions - Help! | Excel Discussion (Misc queries) | |||
| Is there a way to retain a formula while performing cut/paste? | Excel Worksheet Functions | |||
| Can you drag/drop rows w/o using Cut/Paste | Excel Discussion (Misc queries) | |||
| Excel cut/paste prob: Adds one day and changes year to 2009 | Excel Discussion (Misc queries) | |||
Threaded Mode
