Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data table, two-input
I am trying to use the data table command. For some reason, I get the same
output value (the original value) in every cell of the matrix. I can't figure it out! Please help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
data table, two-input
Exclude calc mode first. It may be set to "Manual" or "Auto except tables"
mode. Press F9, does it compute properly? Check/Change the calc mode via Tools Options Calculation tab. If it isn't the calc mode, then you might not have set it up correctly. Try this illustrative sample from my archives to get a quick grasp: http://savefile.com/files/46276 2 variable data table example.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jig" wrote: I am trying to use the data table command. For some reason, I get the same output value (the original value) in every cell of the matrix. I can't figure it out! Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Input cell on Data Table will not work | Excel Discussion (Misc queries) | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
changing proportion of chart and data table | Charts and Charting in Excel |