Using scenario manager with data tables

%3CLINGO-SUB%20id%3D%22lingo-sub-2668733%22%20slang%3D%22en-US%22%3EUsing%20scenario%20manager%20with%20data%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2668733%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20building%20on%20an%20existing%20Excel%20model%20that%20uses%20data%20tables%20as%20part%20of%20its%20calculations%2C%20and%20I%20want%20to%20use%20multiple%20scenarios.%20I%20would%20like%20to%20use%20scenario%20manager%2C%20but%20will%20the%20data%20tables%20update%20automatically%20when%20I%20run%20the%20scenarios%20through%20scenario%20manager%3F%20I%20don't%20want%20to%20re-make%20the%20existing%20model%20from%20scratch%20to%20run%20with%20scenario%20manager%20instead%20of%20data%20tables%20because%20it's%20very%20big%20and%20complex%20and%20I%20don't%20want%20to%20make%20a%20mistake%20in%20reconstructing%20it.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2668733%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

Dear all,

 

I am building on an existing Excel model that uses data tables as part of its calculations, and I want to use multiple scenarios. I would like to use scenario manager, but will the data tables update automatically when I run the scenarios through scenario manager? I don't want to re-make the existing model from scratch to run with scenario manager instead of data tables because it's very big and complex and I don't want to make a mistake in reconstructing it.  

 

Thanks in advance

0 Replies