Clear Memory Cache

[ExcelRoy]

Hi,

I have a workbook with lots of code and formulas, one of which copies data from another workbook, which used to work quite quick, but is now painfully slow

Is there a code to clear the cached memory that I can call against my different codes to copy data?

many thanks for any help