diff --git a/ClosedXML/Excel/XLWorkbook_Save.cs b/ClosedXML/Excel/XLWorkbook_Save.cs
index 2341def..750e924 100644
--- a/ClosedXML/Excel/XLWorkbook_Save.cs
+++ b/ClosedXML/Excel/XLWorkbook_Save.cs
@@ -1996,15 +1996,14 @@
                 else
                 {
                     var workbookCacheRelId = context.RelIdGenerator.GetNext(RelType.Workbook);
+                    pt.WorkbookCacheRelId = workbookCacheRelId;
                     pivotCache = new PivotCache { CacheId = cacheId++, Id = workbookCacheRelId };
+                    pivotCaches.AppendChild(pivotCache);
                     pivotTableCacheDefinitionPart = workbookPart.AddNewPart<PivotTableCacheDefinitionPart>(workbookCacheRelId);
                 }
 
                 GeneratePivotTableCacheDefinitionPartContent(pivotTableCacheDefinitionPart, pt, context);
 
-                if (String.IsNullOrWhiteSpace(pt.WorkbookCacheRelId))
-                    pivotCaches.AppendChild(pivotCache);
-
                 PivotTablePart pivotTablePart;
                 if (String.IsNullOrWhiteSpace(pt.RelId))
                     pivotTablePart = worksheetPart.AddNewPart<PivotTablePart>(context.RelIdGenerator.GetNext(RelType.Workbook));