Please help, External links need to be automatically updated with Scenarios

[mattpolyak]

I have let's say two sheets linked between one another. One sheet has external links
to the other and vice versa the first sheet let's call it the "master sheet" has about 3 different scenarios 1, 2, and 3 if I were to input "1" into a cell on the master sheet, then a number of values in worksheet 2 change This is controlled by an "IF" formula however, worksheet 2 has a number of values calculated from this function that eventually tie back to the master sheet the problem i'm running into at the moment
is when I have worksheet 2 closed and pick a scenario 1, 2, or 3. The cells don't update.




Master wksht:
[TABLE="width: 298"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD]Operating Case:[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Worksheet 2 formula:

[/TD]
[TD][/TD]
[TD][/TD]
[TD]3


[/TD]
[/TR]
</tbody>[/TABLE]
=IF('[Offshore Drillers Compsheet.xlsx]Sheet1'!$T$2=1,0,IF('[Offshore Drillers Compsheet.xlsx]Sheet1'!$T$2=2,$FT93,IF('[Offshore Drillers Compsheet.xlsx]Sheet1'!$T$2=3,'[Offshore Drillers Compsheet.xlsx]Sheet1'!$U$14,0)))



Then I have in a different cell back in the master worksheet linking to let's say a Revenue number that is summed off the Worksheet 2 formula and I have that linked back into the Master worksheet.

The issue I have is that I need the values for this revenue number to automatically update on the Masterworksheet when I pick one of the scenarios and have worksheet 2 closed. Is this possible? How?


Please help, it would be very greatly appreciated!!!

Thank you very much.