When I try and save down a sheet the has a pivot table in it using the
following visual basic I get the following error "Excel cannot complete
this task with available resources.
Choose less data or close other applications". Any suggestions?


ChDir Path
ActiveWorkbook.SaveAs Filename:= _
Name, FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=False