See my notes below

>Hi all
>
>I have 2 Excel Workbooks - WB1.XLS & WB2.XLS
>
>WB2 has cells with formula link to cell values in WB1
>WB2 also has so macro to create charts from some data range that is linked to WB1
>
>If I change the cell values in WB1, is there a way to refresh the cells in WB2 programtiaclly without opening WB2

To update links Workbook should be open. Either user controls the behavior when opening workbook, or you control it via Excel automation:

oExcel.Workbooks.OPen(filename, .T.)

>
>Is there a way to run the macro in WB2 to refresh the charts in WB2 and also print charts in WB2 to a PDF file programatically?

See Thread #1060492

>
>Your advice much appreciated.
>
>Thanks & Best Regards