I have a macro that includes the 'ActiveWorkbook.RefreshAll' which has been working fine for months, but the workbook is now in use by someone else and they have advised the macro is no longer working.

When I test the macro, its does work but it asks to open the relevant file 3 times before it carries on with the rest of the macro. Any ideas as to why this is happening? the macro looks as follows:

Please Login or Register  to view this content.