Forum Discussion
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...
Same problem here.
Brand new spreadsheet. Autosum a list of numbers. Formula works fine. Copy the autosummed cell and you get the original sum value instead of a (relative) formula.
It's a sad day when Excel cannot copy and paste a formula. Cannot be classed as a spreadsheet until this is fixed. Meanwhile your subscription fee continues to burn down for a product that doesn't do the basic function.
Booked a restaurant the other night and was asked to prepay. When I got there I found out they didn't serve food... Microsoft Cafe 😉