All,

I have a large workbook (45Mb) containing a tab at the back where a lot of calculations take information captured on other tabs and parses it across several tens of thousands of rows in a pre-formatted template for upload into a database application for use by others. The upload tab is large enough that autocalc was slowing down response time significantly (~10 sec to recalc the workbook). I added a VBA macro to the workbook that allows the user to temporarily disable autocalc on this last tab long enough to enter any required data in the other tabs. The user then re-enables autocalc on the last tab prior to uploading the results to the db system.

After an initial trial deployment that involved loading all the other 70+ tabs with simulated trial run data, I received feedback that the upload sheet was not generating the correct results. Digging into it, I found that some rows were calculating correctly while other rows were not. On any cell that is not calculating correctly, if I highlight the cell, click in the formula bar at the top, and hit Enter, it will then return the expected result.

Any thoughts on what might be causing this behavior?

VBA macro I'm using to disable/reenable calculation on the upload sheet:

Sub DisableACESCalculations()
Me.Worksheets("ACES UPLOAD").EnableCalculation = False
End Sub

Sub EnableACESCalculations()
Me.Worksheets("ACES UPLOAD").EnableCalculation = True
Application.Calculate
End Sub
Thanks,

Tom