MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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