|
two-way variable table keeps repeating same value
HELP!! I am building a two-way variable data table and everytime I press OK,
it just repeats the upper-most left column result which is the formula that is referenced. PLEASE HELP!! I need to get this done. |
Answer: two-way variable table keeps repeating same value
I'm sorry to hear that you're having trouble with your two-way variable table. It sounds like the formula you're referencing in the upper-left cell of the table is not set up correctly. Here are a few things you can try to fix the issue:
I hope these tips help you resolve the issue with your two-way variable table. Let me know if you have any other questions or if there's anything else I can do to assist you. |
two-way variable table keeps repeating same value
Try some quick diagnostics:
1. It could be calc mode. Press F9, does it now compute properly? The book may intentionally or inadvertently been set to either Manual, or the semi-auto calc mode called: Automatic except tables (the "tables" are the 1/2 way variable tables which are calc-intensive, hence this option is provided. You press F9 if/when you want the tables to recalc, everything else is auto). Check/correct the calc mode to Automatic via clicking: Tools Options Calculation tab. 2. If (1) is not it, you've probably set it up wrongly. Re-do the DataTable steps, try swapping the row/column inputs around, see whether this returns the correct values. 3. The 1/2 way variable tables need to be created on the same sheet as the base formula. That's the constraint I observed. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Damon G." wrote: HELP!! I am building a two-way variable data table and everytime I press OK, it just repeats the upper-most left column result which is the formula that is referenced. PLEASE HELP!! I need to get this done. |
two-way variable table keeps repeating same value
I ahve tried all of those remedies and nothing seems to work.
1. I have the Tools-Options set to AUTOMATIC Calc. I have even executed the F9 key multiple times. 2. I have tried to swap the order of the rows/columns and even the references. Still no luck. 3. I have the base formula in the cell that it references for the amount. It is a simple "=" the cell with the value and it still just repeats. I am so confused because it's not making any sense to me. If you have any other tricks up your sleeve, I am all ears. Thank you so much for the earlier advice. This is very baffling. "Max" wrote: Try some quick diagnostics: 1. It could be calc mode. Press F9, does it now compute properly? The book may intentionally or inadvertently been set to either Manual, or the semi-auto calc mode called: Automatic except tables (the "tables" are the 1/2 way variable tables which are calc-intensive, hence this option is provided. You press F9 if/when you want the tables to recalc, everything else is auto). Check/correct the calc mode to Automatic via clicking: Tools Options Calculation tab. 2. If (1) is not it, you've probably set it up wrongly. Re-do the DataTable steps, try swapping the row/column inputs around, see whether this returns the correct values. 3. The 1/2 way variable tables need to be created on the same sheet as the base formula. That's the constraint I observed. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Damon G." wrote: HELP!! I am building a two-way variable data table and everytime I press OK, it just repeats the upper-most left column result which is the formula that is referenced. PLEASE HELP!! I need to get this done. |
two-way variable table keeps repeating same value
Option 1:
I have 2* sample files on data table in my archives: *one variable, 2 variable One variable data table example.xls http://savefile.com/files/1007074 2 variable data table example.xls http://savefile.com/files/46276 Take it away & try checking the differences between example (2) above & what you've set up over there. Option 2: If you're still unable to get it going despite the above, upload your sample file using a free filehost, then post a link to it here Eg, you could use this free filehost to upload: http://www.freefilehosting.net/ Copy the "direct link" which is generated after you upload, then paste it here in your reply I'm using xl03, so pl save/upload only as this version (if you're using xl07) I'm not able to open/read xlsx files. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Damon G." wrote: I have tried all of those remedies and nothing seems to work. 1. I have the Tools-Options set to AUTOMATIC Calc. I have even executed the F9 key multiple times. 2. I have tried to swap the order of the rows/columns and even the references. Still no luck. 3. I have the base formula in the cell that it references for the amount. It is a simple "=" the cell with the value and it still just repeats. I am so confused because it's not making any sense to me. If you have any other tricks up your sleeve, I am all ears. Thank you so much for the earlier advice. This is very baffling. |
two-way variable table keeps repeating same value
Damon G. -
I have step-by-step instructions with screenshots for preparing one-way and two-way data tables. At http://www.treeplan.com, on the "Chapters" page, you can download the pdf file for chapter 2, Sensitivity Analysis Using Excel. Or, directly, the file is http://www.treeplan.com/02_decan_20071029_1042.pdf - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "Damon G." wrote in message ... I ahve tried all of those remedies and nothing seems to work. 1. I have the Tools-Options set to AUTOMATIC Calc. I have even executed the F9 key multiple times. 2. I have tried to swap the order of the rows/columns and even the references. Still no luck. 3. I have the base formula in the cell that it references for the amount. It is a simple "=" the cell with the value and it still just repeats. I am so confused because it's not making any sense to me. If you have any other tricks up your sleeve, I am all ears. Thank you so much for the earlier advice. This is very baffling. "Max" wrote: Try some quick diagnostics: 1. It could be calc mode. Press F9, does it now compute properly? The book may intentionally or inadvertently been set to either Manual, or the semi-auto calc mode called: Automatic except tables (the "tables" are the 1/2 way variable tables which are calc-intensive, hence this option is provided. You press F9 if/when you want the tables to recalc, everything else is auto). Check/correct the calc mode to Automatic via clicking: Tools Options Calculation tab. 2. If (1) is not it, you've probably set it up wrongly. Re-do the DataTable steps, try swapping the row/column inputs around, see whether this returns the correct values. 3. The 1/2 way variable tables need to be created on the same sheet as the base formula. That's the constraint I observed. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Damon G." wrote: HELP!! I am building a two-way variable data table and everytime I press OK, it just repeats the upper-most left column result which is the formula that is referenced. PLEASE HELP!! I need to get this done. |
two-way variable table keeps repeating same value
"=" the cell with the value ...
Your line above presumably should have read as: "=" the cell with the base formula .. Post back & tell us what happened over there, whether you got it up, etc etc -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| All times are GMT +1. The time now is 02:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com