View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NYKarl NYKarl is offline
external usenet poster
 
Posts: 1
Default 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