Apr 29 2009
Excel – Update formulas on Open
Most of the time this is a relatively trivial exercise. In the majority of cases, simply setting ‘Workbook Calculation’ to ‘Automatic’ in the Excel options will give the desired effect. However, I recently stumbled across a situation where this doesn’t work. If you find yourself entering data into an Excel workbook through some other means [...]
