I have an issue here: When importing an Excel file which contains Macro based formulas, these cells only yield missing values instead of their actual values. How can I import this data correctly?
Note: I assume that the values are stored in the Excel file, similar to the values of normal formula cells, because when I open the file in Excel with deactivated macros, the values are well present.
Here's a screenshot illustrating the missing values: