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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
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.
 
Upvote 0

Forum statistics

Threads
1,218,658
Messages
6,143,736
Members
450,502
Latest member
sakaria_123

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
Back
Top