pasting data, but not formula

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

All of a sudden, when I click and drag to paste a formula,
it only showing that it is pasting the data. If I save
it, it will show that it saved the formula as well and the
data will change. Any ideas?
 
This is a financial spreadsheet that I use to track all
kinds of numbers (this problem is happening to all my .xls
files, however). And, not only are cells that I copy and
paste not updating, but also Total cells. For instance, I
plug in a sales number, and the month to date column which
calculates monthly sales up to the last days sales, does
not update until I click the 'Save' button. This is brand
new to me. That is one symptom, hope you can help.
Thanks.
 
Back
Top