Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data table is not updating correctly in excel 2003
I have found 3 sets of identical instructions for getting data tables to work
(including the simple instructions included with excel 2003) but my data table will not work. I enter the variables that I want in a column (A20:A29 in this case). I enter a link to the formula that I want in B19 (in this case '=Profit', which is defined elsewhere). I get the correct answer for B19 (based on the non-variable value I have above). In this case the profit function depends, among other things on a variable "ResponseRate" which is a named range corresponding to cell E4. So, I have everything set up correctly and I highlight the correct cells, select Data - Table, Column Reference and then type in either "Response Rate" or "E4" (I've tried both). The Data table instanly fills in the columns, BUT ONLY FOR THE CURRENT VALUE OF "ResponseRate". I know the error is not with my defintion of the formula I have in the range defined as "profit". If I update my actual "ResponseRate" then my profit formula gives me the right answer. But my damn data table just gives me 10 copies of the exact same variable. Please help me with this. I'm going to go insane. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data table is not updating correctly in excel 2003
Perhaps try excluding the calc mode factor first
Press F9 - does it compute properly ? Calc mode may be set to "Manual", or to "Automatic except tables" (the latter is a setting used quite commonly with calc-intensive data tables) To check / change calc modes: Click Tools Options Calculation tab If the above isn't it, then try this working sample implementation (set-up along the lines of your post): http://cjoint.com/?gbc2YQsdBu Data Table.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Nathaniel Givens" wrote: I have found 3 sets of identical instructions for getting data tables to work (including the simple instructions included with excel 2003) but my data table will not work. I enter the variables that I want in a column (A20:A29 in this case). I enter a link to the formula that I want in B19 (in this case '=Profit', which is defined elsewhere). I get the correct answer for B19 (based on the non-variable value I have above). In this case the profit function depends, among other things on a variable "ResponseRate" which is a named range corresponding to cell E4. So, I have everything set up correctly and I highlight the correct cells, select Data - Table, Column Reference and then type in either "Response Rate" or "E4" (I've tried both). The Data table instanly fills in the columns, BUT ONLY FOR THE CURRENT VALUE OF "ResponseRate". I know the error is not with my defintion of the formula I have in the range defined as "profit". If I update my actual "ResponseRate" then my profit formula gives me the right answer. But my damn data table just gives me 10 copies of the exact same variable. Please help me with this. I'm going to go insane. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data table is not updating correctly in excel 2003
Max-
Thanks so much. I actually managed to figure this one out just before you posted - and you were exactly right. For some reason the workbook was set to "calcute automatically except tables". Changing this to "calculate automatically" fixed the problem. I appreciate the response. "Max" wrote: Perhaps try excluding the calc mode factor first Press F9 - does it compute properly ? Calc mode may be set to "Manual", or to "Automatic except tables" (the latter is a setting used quite commonly with calc-intensive data tables) To check / change calc modes: Click Tools Options Calculation tab If the above isn't it, then try this working sample implementation (set-up along the lines of your post): http://cjoint.com/?gbc2YQsdBu Data Table.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Nathaniel Givens" wrote: I have found 3 sets of identical instructions for getting data tables to work (including the simple instructions included with excel 2003) but my data table will not work. I enter the variables that I want in a column (A20:A29 in this case). I enter a link to the formula that I want in B19 (in this case '=Profit', which is defined elsewhere). I get the correct answer for B19 (based on the non-variable value I have above). In this case the profit function depends, among other things on a variable "ResponseRate" which is a named range corresponding to cell E4. So, I have everything set up correctly and I highlight the correct cells, select Data - Table, Column Reference and then type in either "Response Rate" or "E4" (I've tried both). The Data table instanly fills in the columns, BUT ONLY FOR THE CURRENT VALUE OF "ResponseRate". I know the error is not with my defintion of the formula I have in the range defined as "profit". If I update my actual "ResponseRate" then my profit formula gives me the right answer. But my damn data table just gives me 10 copies of the exact same variable. Please help me with this. I'm going to go insane. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data table is not updating correctly in excel 2003
Glad to hear you got it solved !
Thanks for the feedback .. For some reason the workbook was set to "calculate automatically except tables". As data tables can become calc-intensive very quickly <g, think that's why the semi-auto setting: "Automatic except tables" is provided as a selectable calc-mode option -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Nathaniel Givens" wrote: Max- Thanks so much. I actually managed to figure this one out just before you posted - and you were exactly right. For some reason the workbook was set to "calcute automatically except tables". Changing this to "calculate automatically" fixed the problem. I appreciate the response. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
issue with excel 2003 data import | Excel Discussion (Misc queries) | |||
Update Excel table in Word automatically from data in Excel | Excel Discussion (Misc queries) | |||
Can I copy a table from Word into one cell in Excel without losing data? (Office 97) | Excel Discussion (Misc queries) | |||
problem with downloading Data into Excel 2003 | Excel Discussion (Misc queries) |