Error when loading workbook with multiple pivot tables sharing common data sources

[Havimo]

Expected Behavior

Workbook is loaded as normal in the global environment

Actual Behavior

Workbook fails to load with this error message :

Error in sprintf("<Relationship Id=\"rId%s\" Type=\"http://schemas.openxmlformats.org/officeDocument/2006/relationships/pivotCacheDefinition\" Target=\"pivotCache/pivotCacheDefinition%s.xml\"/>",  : 
  arguments cannot be recycled to the same length

Steps to Reproduce the Problem

(please attach an example xlsx file if possible)

It seems this problem occurs when there are 3 (or more) pivot tables with 2 of them sharing a common data sources. Please see very simple .xlsx file attached mre_openxlsx.xlsx

sessionInfo()

• Version of openxlsx:

  > packageVersion('openxlsx')
  [1] ‘4.0.33’

• Version of R:

  platform       x86_64-w64-mingw32          
  arch           x86_64                      
  os             mingw32                     
  system         x86_64, mingw32             
  status                                     
  major          3                           
  minor          4.1                         
  year           2017                        
  month          06                          
  day            30                          
  svn rev        72865                       
  language       R                           
  version.string R version 3.4.1 (2017-06-30)
  nickname       Single Candle  

[anurag3290]

Try using 'xlsx' package instead of 'openxlsx'. Alternatively, can try : wb = xlsx::loadWorkbook(base_file)