Move data - what happens to formula's
Yes it will affect your formulae. When you cut the source data that is
refered in the formula and paste it elsewhere your formula may Show
#REF!, which means your references are missing. It may not happen for
simple formulae as excel adjusts the references to the new place of
the data. But if you do see #REF! appearing in your formulae then all
you have to do is go to your formulae and edit the #REF! with the new
cell ranges.
|