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

##</code><code>##

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

##</code><code>##

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