If calculation is set to manual and I hit the F9 key the Workbook updates correctly.
Please hit Yes if my comments have helped.
Thanks.