#### mattpolyak

##### New Member
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:

 Operating Case: 1 1 2 Worksheet 2 formula: 3

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
=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?

Thank you very much.

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Replies
5
Views
113
Replies
8
Views
273
Replies
0
Views
138
Replies
1
Views
170
Replies
3
Views
335

1,203,203
Messages
6,054,120
Members
444,703
Latest member
pinkyar23

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back