Pivot Table preventing workbook from refreshing

[amphinomos]

Hi,

I've got a workbook with a several pivot tables. For convenience, I've deleted the pivot table source and left the pivots "self-standing". Problem is now when I try to refresh the workbook, I get a "Reference is not valid" error which prevents the workbook from updating. Is there a non-vba workaround to this problem ?

Thanks,
amphi

[cbatrody]

Hi,

Why would you want to refresh the Pivot Table when you have deleted the source data?

[amphinomos]

I don't want to refresh the pivot. I want to refresh the rest of the workbook.