Hi, I can't get some values from some cells containing formulas, I get #NAME! or #VALUE! instead. Now, this wouldn't be a problem if I knew that those formulas don't work, but they do! I know that because I can read values representing formula results from other cells just fine (some of them containing more complicated formulas than the ones in question). Also, if I open Excel manually and look into those cells, I see "normal" values (numbers).

I'm using Win32::OLE, and the code goes something like this:

my $value = $MYWORKSHEET->Range("B35")->Value();
[download]

or

my $value = $MYWORKSHEET->Range("B35")->Text();
[download]

This excel is linked to another file, and I get that by setting

$MYWORKBOOK->{UpdateLinks} = 3; # 3 means update links always
[download]

(both excel files are opened anyway)

Am I missing something?