Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Table
I thought I posted this here last week, but don't see it, so here goes
again! Question for you, please: In the past, if I wanted to use an EXCEL data table, I was sure that the "row input" and "column input" cells needed to have values in them. It needed to be, for example, 3, not even =3, since the latter is a formula. That made sense to me. Recently, I had a data table suing a certain input cell but replaced that cell's value with a formula and, to my surprise, the data table results did not change and it seems to work anyway, which kind of blows me away. You would think that EXCEL would object to changing a cell that has a formula in it, wouldn't you? It seems that it is simply ignoring the formula and replacing it with the values you ask it to test. I am using EXCEL 2003. Are you seeing the same phenomenon? Does it make sense to you? Is this a recent update to EXCEL 2003 that was not there before. Thanks Dean |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I detail Pivot Table data without creating a table (Excel2007) | Excel Discussion (Misc queries) | |||
View Pivot Table Source data as a Data Table | Excel Discussion (Misc queries) | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
Write data to Access table with INSERT when table has auto number | Excel Programming | |||
Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) |