Hi,
My workbook contains several pivots from different sources. On one pivot I've deleted the source therefore the data is all in the cache. My problem is that when I refresh the workbook I get an annoying "Cannot open pivot table source file". Is there an simple way of preventing that specific pivot table from refreshing when all the others are ? Any help would be appreciated !
Thanks
amphinomos
Bookmarks