Hello -
I have the following UDF set up to calculate the break- even point in excel.
The UDF is referenced on multiple tabs throughout the workbook. When one tab is refreshed, ALL of the tabs that reference the same UDF are updated to the same number (although the cash flows are different on the various tabs, and I'd expect the number to be different as well).
For example, let's say tab1-cellA1 should show "5" and tab2-cellA2 should show "10". If I click on tab 1-cell A1 and refresh, all the tabs now show "5" in cell A1. If I then click on tab 2-cell A1 and refresh, all of the tabs show "10" in cell A1.
Is it possible to update the entire workbook at once and have the correct values be calculated? I can't seem to figure out why excel is updating all tabs to the same value.
Thank you!
Please Login or Register to view this content.
Bookmarks