Data Table problem (Excel 2007)

Mr930

Well-known Member
Joined
Aug 31, 2006
Messages
583
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
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Mr930

Well-known Member
Joined
Aug 31, 2006
Messages
583
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,216
Messages
5,594,885
Members
413,947
Latest member
gizmolucy

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