“Input cell reference is not valid” – how to create a Data Table in ANY sheet
by Rickard Wärnelid on May 25 2009
"Input cell reference is not valid" - Excel error message
Working with Data Tables in Excel is essential knowledge to anyone active in financial modelling using Excel. Using Data Tables one can achieve amazingly powerful scenario analysis with consistent and graphically appealing outputs.
Typical scenario manager for financial analysis - Link this to data table
If you have ever tried to create a data table using inputs from another sheet you may have seen the error message “Input cell reference is not valid”. This appears to be a limitation of what can be done with Excel Data Tables, however there is a neat and efficient work-around to solve this problem. We have put up a Data Table Tutorial on the main Corality website with a sample workbook outlining the solution.
Hopefully this will put an end to the common statement that it is ‘impossible’ to create a data table in a sheet different to where the assumption is….
Read the full Excel Data Table tutorial
