{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 趁早两清 的问题《Excel is not calculating formulas》','https://www.manongdao.com/q-1012514.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I have an Excel template where the underlying values are updated via SAS. There are predefined formulas in the template that do not update when the data changes.
The workbook is set to automatic calculation. F9, or any combination of keys and F9, does not update the cells. The only way to update them is to click inside the formula box and hit enter. The cells are not formatted as text.
These are simple formulas such as
=Data!A1
There are no error messages. The cell displayed values simply do not update.
After that data has been refreshed touch:
Ctrl+Alt+Shift+F9
This is equivalent to issuing the VBA command: