| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. Jai |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create link with sheet which is not inserted into workbook
I don't believe so,
if you click on the cell and hit enter it will recognise it but using the indirect function will update the cell as soon as the first calc is done =indirect("Sheet4!A1") will give you the ref error until the first calc after enter sheet 4 "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. Jai |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create link with sheet which is not inserted into workbook
Thankyou so much bj for explaining the answer. It will fulfil my need.
"bj" wrote: I don't believe so, if you click on the cell and hit enter it will recognise it but using the indirect function will update the cell as soon as the first calc is done =indirect("Sheet4!A1") will give you the ref error until the first calc after enter sheet 4 "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. Jai |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link spread sheet to another workbook | Excel Discussion (Misc queries) | |||
| Link individual sheet to one sheet in another workbook | Excel Discussion (Misc queries) | |||
| how do i link from one sheet to another in the same workbook? | Excel Worksheet Functions | |||
| link cell from one sheet to another within the same workbook | Excel Discussion (Misc queries) | |||
| How can I create a link to a specific sheet from external web page | Excel Discussion (Misc queries) | |||
Linear Mode
