refresh excel

[yucatan 0]

hello guys

i wanne refresh all data in a excel sheet.

so that it read the file and shows the data without closing and starting excel again.

Thx

[somdcomputerguy 98]

There doesn't appear to be a refresh function in the Excel UDF, wouldn't the close and open functions kinda do the same thing? I don't use Excel, so I can't say for sure..

[JoHanatCent 7]

All depends what refresh mean.

Do you add data all the time to Exel and want to read this? Do you want to ReCalc?

You also need to save Excel sooner or later.

[PsaltyDS 24]

Turning the automatic update off/on will force an immediate update:

$oExcel.Application.ScreenUpdating = False
$oExcel.Application.ScreenUpdating = True

You might also use:

$oExcel.ActiveSheet.Calculate