Forum Discussion

Arleigh_Hays's avatar
Arleigh_Hays
Copper Contributor
May 12, 2023

Excel Formulas Change to Values When Anything is Pasted Anywhere in the File

  I have an Excel spreadsheet with two tabs: Summary and Data. The Summary worksheet has several tables that use COUNTIFS formulas. I started noticing that my formulas were randomly changing to valu...
excel
Formulas and Functions
office 365
KuEva's avatar
KuEva
Copper Contributor
Nov 29, 2023
Hi There,
I have the same issue and it's really inconvenient. Also not too promising that no-one found a solution for it in half a year (and not much people complaining either).

I tore up my excel settings and I couldn't find an option remotely close to this issue.
😞
  • Jimmy1988's avatar
    Jimmy1988
    Copper Contributor
    Mar 19, 2024

    KuEva All this time later and still no real fix! 

     

    Its not a solution by any means but, save and close the doc, then open it again and try the paste. 

    This worked for me, it must be a bug that finds its was into your current file but goes after a save and close. 

     

    Hopefully this works for you. 

Resources