title: Unable to upload password-protected file into R anymore
body: <p>I initially used this code to upload a password-protected Excel spreadsheet into R. It worked completely fine and I was able to read the file.</p>
  <pre><code>library(&quot;readxl&quot;)
  library(&quot;dplyr&quot;)
  library(&quot;excel.link&quot;)
  library(&quot;tinytex&quot;)
  
  new_path = paste0(tempdir(), &quot;\\&quot;, &quot;Bone_Dataset_7-13-2022.xlsx&quot;)
  xl()[[&quot;Activeworkbook&quot;]]$saveas(new_path, AccessMode=xl.constants$xlExclusive)
  ###
  xl()[[&quot;Activesheet&quot;]]$Unprotect(password = &quot;Password&quot;)
  bonedata = crc[a1]
  xl.workbook.close()
  unlink(new_path) # remove temporary Excel File
  
  BoneData &lt;- bonedata
  BoneData
  </code></pre>
  <p>However, I am trying to knit my r.markdown file, and the code no longer seems to be working. It uploads a file with only 1 row and one column in it (there should be ~1500 rows).</p>
  <pre><code>Description:df [1 × 1]
  
  |      |a              |
  | -----| --------------|
  | 1    | NA            |
  
  </code></pre>
  <p>What am I doing wrong here? Why did it work before, but not now??</p>
  <p>Thank you so much!</p>