XLConnect - excel formulae evaluation

[nehaumesh]

I am trying to use XLConnect to read an excel file with multiple sheets and formulae into R. I am able to do that and also change a particular formula. But the excel sheet does not evaluate based on the changes. It only evaluates when I manually open the excel file. Is it possible to make changes in the R environment and also to evaluate in the R environment only without opening the excel file.

This is needed as I need to make multiple changes and for each change need to store the final results in a table (Sensitivity analysis).