Excel 2007 SP1 - VBA "Calculate" cannot be relied on!


Ron West

Referring to my post "Excel 2007 SP1 - How to do F9 in VBA code?" in
microsoft.public.excel.misc , it seems that VBA "Calculate" cannot be relied
on when using Reuters RtGet() libraries.

Pressing F9 does an immediate recalculate/refresh - but looping through
repetitive "Calculate" statements in VBA code does NOT refresh the Reuters
data cells.

If this is a bug in Excel 2007 SP1 (and not my fault somehow), then
Microsoft MUST FIX IT FOR SP2, else Excel will be worthless in major parts of
the Investment Banking world.



Charles Williams

Application.Calculate works fine for me in Excel 2007.

I suspect the problem is either in your vba code or the way your system is
setup or in the Reuters functions.
(Reuters functions are believed to do something strange like rewriting
themselves after a Calculation event)

Its hard to pin down without closer inspection.

London Excel Users Conference April 1-2
The Excel Calculation Site

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question