pasting data, but not formula

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?
 
J

John Walkenbach

That's a strange one -- and the lack of replies confirms it. Is there
anything else you can tell us? Maybe describe exactly what you do and what
happens when you do it.

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss
 
J

Jason

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.
 
Top