| 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 |
| 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) | |||
Threaded Mode
