Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
tango
 
Posts: n/a
Default 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?


  #2   Report Post  
JulieD
 
Posts: n/a
Default

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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I look up data in a different workbook in an excel spread. DoctorG Excel Worksheet Functions 10 January 13th 06 09:18 PM
Can Excel Export Data to Word Format? Reddiance Excel Discussion (Misc queries) 2 April 18th 05 06:03 PM
Moving blocks of data in excel Yasmin Excel Discussion (Misc queries) 1 March 17th 05 10:39 PM
How do I create a list in excel that contains external data? bill@bb Excel Discussion (Misc queries) 1 February 15th 05 02:45 AM
Help with Charting My Data -- DavidM Charts and Charting in Excel 7 January 7th 05 01:08 PM


All times are GMT +1. The time now is 02:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"