Excel cannot complete this task with available resourc essage when updating my pivot table

Can somebody help?
I am using Excel 2013, and tried the obvious: closing programs disabling automated calculations and add-ins. still having the same issue.

Full message:

"excel cannot complete this task with available resources. choose less data or close other applications"

Restart your PC.

Hello, done too, too many times. still have the same.

Maybe you need to reduce the processing overhead.

Try running my optimise subroutine

work with your pivot table

run deoptimise.

Sub optimise()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False
Application.DisplayStatusBar = False
'Application.Calculation = xlCalculationManual
ActiveSheet.DisplayPageBreaks = False
End Sub

Sub Deoptimise()
Application.ScreenUpdating = True
Application.DisplayAlerts = True
Application.EnableEvents = True
Application.DisplayStatusBar = True
'Application.Calculation = xlCalculationAutomatic
ActiveSheet.DisplayPageBreaks = True
End Sub