copy cell value from one sheet to another sheet

[elsuji]

Hi

I am writing formula for cell value one sheet to another sheet.

For example i want value is copy from sheet1 C5 to Sheet2 D6. For that i am writing =Sheet1!C5 on Sheet2 cell D6. The value is updating ot the tile of writing this formula. But after that when ever i am changing the value on Sheet1 C5 it is not updating Sheet2 D6 automatically. i want to update it manually or while opening the wrokbook it is updating.

Can any one please help me how to update this automatically when ever i am changing the value on Sheet1 C5.

[SamT]

At some time... somewhere in some Workbook... Application.Calculation = xlCalculationManual. That will stop all formula cell references working.

In the Thisworkbook Code Page

Option Explicit

Private Sub ResetApplication()
    Application.Calculation = xlCalculationAutomatic
End Sub

run the ResetApplication Sub manually, then find where Calculation was set to xlCalculationManual and fix that code.