View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Formula in one cell changes when data in another cell is cut and pasted.

Hi David,

Am Sun, 23 May 2021 10:05:35 -0700 schrieb David Farber:

Does it work for you (meaning Excel doesn't modify the formula in column
"I") even if you enter an "X" in one cell, and then change your answer
by cutting and pasting "X" into another cell? Maybe a later version of
Excel has fixed the problem?


when you cut and paste the "x" the references in the formula will be
changed and the formula isn't working any more.
You must delete and rewrite the "x".


Regards
Claus B.
--
Windows10
Microsoft 365 for business