Hello,

I have 2 files, of the same name, say Test.xlsx that's in different folder.

i.e. 'My Documents\2018\Jan\Test.xlsx' and 'My Documents\2018\Feb\Test.xlsx'.

Now let say I have a sheet named 'ActualJan.xlsx' in 'My Documents\2018\Jan\'

After which, I make a copy of 'ActualJan.xlsx' and 'Test.xlsx' to 'My Documents\2018\Feb\ folder...and rename the file to 'ActualFeb.xlsx'

In actuality, both files are of the exact same, i.e. formula wise, and even the link to the external workbook, which in this case is still looking at 'My Documents\2018\Jan\Test.xlsx'.

Now visualize that I opened up my 'ActualFeb.xlsx' file, and run the macro, where the macro make the changes from the folder path Jan to Feb.

The problem here is that since my 'Test.xlsx' is of the same file name, WITHOUT opening both source files, it takes a very long time to make the changes (I looked at the file, and someone had 20 columns x 1869 rows of SUM(IF(...)) array formula PER SHEET x 5 sheets).

I am wondering if there's any solution to speed up my .changelink process?