Excel 2007/ In put Cell reference is not valid While using What If Analysis

Anonymous
2010-02-01T22:25:01+00:00

Hi

I am getting this error when i am suing What If Analysis ,When the referencing value is not in the same Sheet of Calculation

I.E-If sheet one Has alll the calculation and we are trying to use the What If Analysis in Sheet to this What we Get"In put Cell reference is not valid While using What If Analysis"

If the Same function is used in the same Sheet then It will Give the right Value

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2010-02-06T21:49:22+00:00

For a Data Table, the input cells must be on the same sheet as the Data Table...

but, the formula used to fill the table can be in another sheet, via reference.

Since that is apparently an Excel limitation, the best approach is to work with Excel...not against it. ;)

I hope that helps.

(Please post back if you have more questions.)

Best regards,

Ron Coderre

Microsoft MVP - Excel (2006 - 2010)

P.S. If this (or any other) post answers your question, please mark is as the Answer

(That way it won't keep showing as an open item.)

Was this answer helpful?

70+ people found this answer helpful.
0 comments

2 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2010-02-06T21:15:26+00:00

    Data Table

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2010-02-02T00:14:23+00:00

    When I use Goal_Seek, I can have the calculation cells and

    the input cell on different sheets in the same workbook with no issues.

    Which functionality under What If Analysis are you attempting?

    ...Scenario Manager? Goal Seek? Data Table?

    Was this answer helpful?

    0 comments