Create link with sheet which is not inserted into workbook
 

I have a workbook containing Sheet 1, Sheet 2, Sheet3. If I write in cell A1
"March"
of Sheet 1 and then put formula (=Sheet1!A1) in A1 of Sheet 2 it gives
"March" in result. And if I put formula (=Sheet4!A1) then it result #REF!
because Sheet 4 is not inserted. Is it possible ? If I insert Sheet 4 and
write "March" in cell A1 automatically #REF! turns into "March" without
changing formula of cell A1 of Sheet 2.

Create link with sheet which is not inserted into workbook
 

You are correct that if the sheet has no where to reference it will come back
as #REF. Once the sheet is inserted into the workbook it will read what ever
is in that cell. If you are wanting it to be the same as Sheet1A1 I would
suggest using the same link to Sheet1A1 for less confusion down the road.

"jai" wrote:

I have a workbook containing Sheet 1, Sheet 2, Sheet3. If I write in cell A1
"March"
of Sheet 1 and then put formula (=Sheet1!A1) in A1 of Sheet 2 it gives
"March" in result. And if I put formula (=Sheet4!A1) then it result #REF!
because Sheet 4 is not inserted. Is it possible ? If I insert Sheet 4 and
write "March" in cell A1 automatically #REF! turns into "March" without
changing formula of cell A1 of Sheet 2.