Refreshing FactSet Codes/Functions

[mikeymay]

I am using an add-in called Factset which I refresh on a global basis (multiple sheets in the workbook) with the following line of code

ExecuteExcel4Macro "FDSFORCERECALC(FALSE)"

This code executes a refresh across the whole worksheet but I need to be able to run a refresh on individual pages.

The workbook consists of a number of worksheets detailing specific information and the user may not need all of the them so dependant on which ones are required I need to the Factset refresh to execute on individual pages.


TIA

 

[CarlEngland]

MikeyMay, apologies but I don't have an answer to your question - rather I am stuck with the VBA code that will force a FactSet code, ie, =FDS( etc etc ) refresh. For workbook or sheets. Would you mind sharing please? Cheers