r - Getting numbers computed with formulas with XLConnect -

i'd read numbers in excel spreadsheet using xlconnect package. impression fails read numbers computed inside excel using formula dollar sign. there solution problem ?

i ran same problem.

have looked @ parameter 'usecachedvalues' readworksheet function? here doc on parameter:

usecachedvalues logical specifying whether read cached formula results workbook instead of re-evaluating them. particularly helpful in cases reading data produced excel features not supported in xlconnect references external workbooks. defaults false, means formulas evaluated xlconnect.

i specified usecachedvalues=true. while formulas in case did not involve references external links, worked me , able read in values.