Problem with named ranges
Posted by David Dougherty on November 09, 2001 2:04 AM
Ihave a work sheet called "M QTRLY TARGETS". There are various named ranges within this sheet. On another sheet called "Service Credit Calculator" I have a number of lookup formulas that refer back to the named ranges. For some reason, when I change figures within a named range, my look up formulas continue to show the original value - can you help ?
Posted by Aladin Akyurek on November 09, 2001 3:10 AM
Perhaps you have the calculation set to manual instead of automatic. See the Calculation tab (Tools|Options).
============
