Recalculate the report

All the recalculate options described in this section only recalculate Q&A Cloud queries.

To recalculate Microsoft® Office Excel based formulas, additional steps must be added to the macro. Excel is not forced by the Q&A DataLink Server to move to Manual Calculation methods.

Recalculate workbook

To create a macro that recalculates an entire workbook, add this method in to your macro:

Sub RecalculateWorkbook()
QAAMacro.Recalculate
End Sub

This will recalculate all Q&A DataLink Server queries in that workbook.

Recalculate worksheet

To create a macro that recalculates a particular worksheet, add this method in to your macro:

Sub RecalculateWorksheet()
QAAMacro.RecalculateWorksheet("SheetName")
End Sub

This will recalculate all Q&A DataLink Server queries in the specified worksheet.

Recalculate range

To create a macro that recalculates a specific range of the active workbook, add this method in to your macro:

Sub RecalculateRange()
QAAMacro.RecalculateRange "A10:G45"
End Sub

Or a specific cell:

Sub RecalculateRange()
QAAMacro.RecalculateRange "H12"
End Sub

The recalculate range only recalculates the active worksheet. When recalculating an inactive worksheet the sheet name is ignored if the formula is preceeded with a worksheet name such as sheet2!E17:C13. Therefore, you must call Excel's standard macro function sheets ("SheetName"). Select before adding a step to recalculate the range.