Data Table problem (Excel 2007)

Mr930

Well-known Member
Joined
Aug 31, 2006
Messages
585
This was not a problem in 2003, looks to be in 2007:

I have a table like this:

A B C
2 # =B1
1.5 # =B2
1 # =B3

Col A is the input to my table, column B are the results. Col C is just pointing to Col B.

If I change the number 2 in Col A for example, the Col B number changes, as it should. However, Col C remains unchanged. I have recalc set to Automatic except tables. I hit F9 and nothing happens. I can change Col A all I want and Col C never changes, but Col B is always correct. Changing recalc options makes no difference.

Now I edit the formula in Col C (make no changes, but save). Now when I change Col A, Col C changes, but it is one step behind, it uses the PREVIOUS value that was in Column B! It continues one step behind if i keep changing Col A.

I thought maybe it was related to the fact I was running in compatibility mode, but I saved to .xlsx but it did not help.

Fred
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Mr930

Well-known Member
Joined
Aug 31, 2006
Messages
585
CTRL-ALT-F9 makes the calculation work, but something has changed from 2003 and it is not at all obvious. This could burn some people.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,982
Messages
5,834,688
Members
430,310
Latest member
Excelorate3305

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top