How to recalculate cell values in Excel 97?

[vip1]

I have an excel workbook connected to the DB though the DLL add-in.
Now it works fine under Office 2000, but not under Office 97.
The Problem is that 97 VBA doesn't support function
CalculateFull, which was used to recalculate cells.
How can I refresh cell values when I get new data from the DB? I've tried Setting
worksheet.enablecalculaton = true,
but this doesn't help - cell values remain previous.

Thank You.

 

[xlbo]

erm
application.calculate

should do it

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244