Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What-If Analysis w Data Table and Input on Different Sheet
Hi,
I've created a what-if analysis with a data table in Excel 2007. For the Column Reference Cell, I'd like to use a cell on another sheet of the same workbook, but Excel gives me an "Input cell reference invalid" error. Is this a limitation of Excel? Does anyone have a workaround? Thx Ben |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What-If Analysis w Data Table and Input on Different Sheet
What is the formula(e) you used that gives the error?
"NYKarl" wrote: Hi, I've created a what-if analysis with a data table in Excel 2007. For the Column Reference Cell, I'd like to use a cell on another sheet of the same workbook, but Excel gives me an "Input cell reference invalid" error. Is this a limitation of Excel? Does anyone have a workaround? Thx Ben |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What-If Analysis w Data Table and Input on Different Sheet
From my experience with Data Table in xl97 & xl2003 (my ver), yes. I don't
have/know about xl2007, but from what you describe, it's still a limitation. I'd just live with it. Get the Data Table up working by having things on the same sheet. Then just mirror it (ie the data table or parts thereof, the inputs etc) somewhere else on other sheet/s via simple link formulas. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "NYKarl" wrote: Hi, I've created a what-if analysis with a data table in Excel 2007. For the Column Reference Cell, I'd like to use a cell on another sheet of the same workbook, but Excel gives me an "Input cell reference invalid" error. Is this a limitation of Excel? Does anyone have a workaround? Thx Ben |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data table, two-input | Excel Discussion (Misc queries) | |||
Data Table Input Limits | Excel Worksheet Functions | |||
Input Cell in One variable data table | Excel Worksheet Functions | |||
I want data on sheet 1 to input into sheet 2 also | Excel Worksheet Functions | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |