Excel 2007 linked sum not working

[rae1950]

Excel 2007
I'm working on an estate evaluation and am having difficulty with Excel and linking of values from ASSETS AND LIAB worksheet to a sum range in the SUMMARY worksheet.
Any help would be appreciated.
If I change the values in the ASSETS AND LIAB worksheet as seen in orange, the TOTAL and REMAINING VARIANCE do not update in the SUMMARY worksheet, altho I29 in the SUMMARY worksheet updates appropriately?
I've check cell formats (no text), auto recalc etc. to no avail.
If I place a number in SUMMARY I29 manually, TOTAL and REMAINING VARIANCE update normally.
The values have been simplified.
Thanks
Rich E