What if analysis data table

%3CLINGO-SUB%20id%3D%22lingo-sub-918464%22%20slang%3D%22en-US%22%3EWhat%20if%20analysis%20data%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-918464%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20am%20working%20on%20doing%20a%20sensitivity%20analysis%20but%20keep%20getting%20the%20same%20value%20in%20all%20the%20cells%20when%20i%20use%20the%20what%20if%20analysis%20data%20table%20option.%20Much%20appreciated%20your%20help%20with%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-918464%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

hi guys,

 

i am working on doing a sensitivity analysis but keep getting the same value in all the cells when i use the what if analysis data table option. Much appreciated your help with this.

1 Reply

@jorge_gu  I was looking for the answer of this and is so simple and at the same time so dificult to find. To the people that in the future has the same problem, you just have to recharge all the formulas on Excel by pressing "F9". And that's all.