title: R Import Excel file with values instead of formulas (multiple sheets)
body: <p>I'm trying to import a Excel sheet with a lot of formulas.</p>
  <p>My goal is to read the values of the formulas.
  I spent a lot of time here, searching for answers and already tried a lot, like using read.xlsx, read_excel, experimenting with the arguments, ... but I can't get it to work. I always receive either N/A or FALSE values instead of the formula value.</p>
  <p>In my opinion a possible reason could be that the variables of the formulas are spread across various sheets. For example: I want to import the values of the formulas on sheet A. Some formulas on Sheet A need the results of other formulas on Sheet A, while these formulas need values from sheets B, C and D.</p>
  <p>Could this be a possible reason for the non-working import and if so, how can I fix it?</p>
  <p>I'm aware that I could solve this problem by opening the .xlsx in Excel and saving the formulas as values, but since the idea of my script is to automize a lot of processing steps, this solution would not be satisfying.</p>
  <p>Thanks!</p>