Excel Data Tables

Question

Excel Data Tables

Anonymous

Excel Data table does not update when doing a sensitivity analysis. Formulas are on automatic and still cells do not update in table. Please help.

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

3 additional answers

Answer 1

Ashish Mathur 101.8K Volunteer Moderator

Hi,

Ensure that there are no circular references in the file. Also, ensure that the numbers in the row and column headers of the Data Table are hard coded (not linked). If none of these suggestions work, then share the download link of the file and show the problem clearly.

0 comments

Answer 2

Excel Data table does not update when doing a sensitivity analysis. Formulas are on automatic and still cells do not update in table.

Your description lacks sufficient detail for us to offer a thoughtful explanation.

But note that there are two "flavors" of Automatic Calculation mode: fully Automatic, and semi-Automatic (i.e. "Automatic Except for Data Tables").

If you have actually set semi-Automatic mode, simple edits to cells do not cause recalculation of data tables.

Instead, we must press f9 (or click Calculate Now or Calculate Sheet) to recalculate data tables.

This is a feature. Its primary purpose is to avoid potentially time-consuming recalculations.

Answer 3

Jim G 134K MVP Volunteer Moderator

Another thing to check is the format of the cells. They must be something other than TEXT for formulas to work.

0 comments

Answer 4

Hi CRP3,

My name is Tim and I’m sorry to see you’re experiencing issues. I will gladly assist you today.

Have you ensured that you’re using the latest version of Office? If so which version are you using?

I look forward to hearing from you.

Kind regards

Tim

Share via

Excel Data Tables

3 additional answers