Formulas not copying from worksheet to sheet

Closed
Frustratedwithexcel - Apr 3, 2012 at 10:51 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 4, 2012 at 02:27 AM
Hi There,

my excel has been doing some funny things lately.

1. When I copy a formula from one worksheet to another, the actual formula does not copy, just the numeral data. Why is that? and how can I fix it?

2. When I "cut" data from a cell to paste into a different cell, the data still remains in the old cell rather than move it. What's wrong with my excel?

Everything was normal but recently something has changed and excel is not functioning as per normal...

Many Thanks,




1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Apr 4, 2012 at 02:27 AM
tools-option-calculation

check whether calcualtion (at the top) is manual
change it to automotive
and save the file
0