ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Two Input Data Tables in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/23522-two-input-data-tables-excel.html)

tango

Two Input Data Tables in Excel
 
I have tried to set up a two input data table just as it was described, but
the numbers in the table always come out the same as the cornerstone cell. I
noticed the table works correctly in older versions of Excel but does not in
Excel 2003. I do not see how the process has changed but either it has or I
am doing it wrong. What is the deal?



JulieD

Hi Tango

works fine for me in Excel 2003 - are you sure calculation is set to
automatic, tools / options / calculation ?

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"tango" wrote in message
...
I have tried to set up a two input data table just as it was described, but
the numbers in the table always come out the same as the cornerstone cell.
I
noticed the table works correctly in older versions of Excel but does not
in
Excel 2003. I do not see how the process has changed but either it has or
I
am doing it wrong. What is the deal?






All times are GMT +1. The time now is 03:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com