datas between sheets

**mertserveren** · 02-28-2014, 07:21 AM

hello everyone

i have copied a data to another sheet. but when i change the data, the copied cell does not change...

**:) Sixthsense :)** · 02-28-2014, 07:33 AM

Instead of copy paste Refer it with cell reference, so that any change in the source will get reflected in the formula reference cells.

**mertserveren** · 02-28-2014, 07:36 AM

i am already entering it as a command like =sheet1!a3

**:) Sixthsense :)** · 02-28-2014, 07:38 AM

Whether the calculation mode of your workbook is set to Automatic or Manual?

**mertserveren** · 02-28-2014, 08:27 AM

it is automatic...

**chinraj** · 02-28-2014, 08:31 AM

Originally Posted by mertserveren

it is automatic...

Close the excel application(all workbooks), re-open and perform the task once again. If not solved, then attach your sample workbook.

Re: datas between sheets