What does it say in the toolbar? Sometimes it maintains a connection to the
data in the original workbook if you pasted in another.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Lisar." wrote:

When I copy and paste a formula to a new cell, the new cell will show the
result from the original location.