Excel Formula not auto updating
Posted by david marais on October 03, 2001 8:47 AM
Use has multiple workbooks with formulas linking info across them
One particular formula which draws info from 1 particular cell in another workbook is not auto updating.If you change the cell ref to something else and then back again to the correct on - it works.Any suggestions
Posted by Barrie Davidson on October 03, 2001 9:12 AM
Try using CTRL+ALT+F9. This forces Excel to recalculate.
BarrieBarrie Davidson
