View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Formula bar needing refreshing ??

I not sure how to put this, but I have formulas that aren't working until I
'refresh??' them.
Here's one of thr
formulas:=IF('Rollup'!G15-'Rollup-prior'!G15<0,'Rollup'!G15-'Rollup-prior'!G15,"")

Basically, if I change the G15 data, the result of the formula doesn't
change until I place the cursor in front of the = in the formula bar,then hit
enter. When I do that, the formula works.

Thanks,

Steve