I've added functionality to my database to allow the user to export data into Excel. One of the many exports is a Gantt chart style file, which pulls dates from the database for the records selected and populates a template Excel file with conditional formatting already set up to calculate the coloured part of the Gantt chart.



However, I am having problems with the fact that the conditional formatting does not work unless I manually go into each cell containing a date and then pressing enter. It's as if it fails to calculate the sheet at the end of the process.

I am using the .Calculate function of my Excel object within VBA but this does not seem to work.

Does anyone know a way of forcing a full calculate of the sheet when exporting records into Excel from Access?

EDIT: Forgot to mention that the entire export is driven by VBA, not by Microsoft wizards or anything like that.