View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default Formulas not updating until file is saved

The file is probably set for manual recalculation - you can press F9 to
recalculate at any time. To set it for automatic recalculation, select
Tools | Options | Calculation Tab.

Pete