Allocated memory exceeded

[azimabadi]

Hi everybody,

I have a funny problem today . Of course i look like this .

anyway, i have a sub in my macro looks like this:

SUB mySub2
          set Sheet = ActiveDocument.CreateSheet
          set chart = Sheet.CreatePivotTable
          chart.AddDimension "Field1"
          chart.AddExpression "1"
END SUB

when i call it from my interface, a new sheet is created and also the PivotTable. But PivotTable shows the error message "Allocated memory exceeded".

What that is funny is, when i openthe properties dialog of PivotTable, then click on "Dimension" tab and then click "OK" Button, the PivotTable shows data.

I have to click the "Dimension" tab first, otherwise the error is there.

I think the PivotTable needs some sort of refresh, i tried chart.Deactivate and then chart.Activate but it dosen't work.

Thanks forward for any Idea.

P.S. : I work with QlikView for Windows 11 SR1 x64

Best regards

Peyman

[azimabadi]

DING!