nickhowell.co.uk

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 – [...]

Read Full Post »

Ok, so i’ve just been working on outputting data from an ASP.NET based web app into an Excel Spreadsheet. I’m not going to go into the details of how to do that, but only how to avoid one little problem i encountered.

Read Full Post »