Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Some of my 2-dimensional data tables stopped working when I made some
changes to a file. Am I right that the column and row input row variables CAN be used in the row across the top and column down the side? That is, none of these needs to be a number? For example, I have a 5X5 data table with the row variable being cell D4, and the entries across the top are d4-100,000, d4 - 50,000, d4, d4+50,000, d4 +100,000. Is this legal? Strangely, a value does appear beneath the 4th entry (d4+50,000), but not below any of the others - they all show "#Value". I'm talking about the first row here and coincidentally, the column entry is a number there, whereas for the other rows, they are equations. In the 2nd row, they all show #value. If I change one of the column scenarios to be tied directly to the column input variable, it does not help and, from the answer showing in the top left corner of the data table, I know this does have a real answer. Do data tables have known problems? It seems like they are finicky? I tried erasing it and copying it in from the older file that did work, but it did not copy the data table matrix formulas. Then I just tired redoing the data table, but that did not help either. Thanks! Dean |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Problems | Excel Worksheet Functions | |||
large data file problems - pivot table with vba | Excel Programming | |||
large data file problems - pivot table with vba | Excel Programming | |||
Pivot Table problems | Excel Programming | |||
I am having problems creating pivot table of data | Charts and Charting in Excel |