Recorded Macro not Working Properly

Hey guys,

I have recorded a macro that allows me to connect different spreadsheets. However sometimes that I run it, a box pops out that says "update values of ____ spreadsheet and I am supposed to click on a file and press open. if I press cancel the box keeps on popping out until I have pressed cancel for several times. Does anyone know how I can get rid of this box?

thank you very much!!

Ilas

Please provide an example of your code or a dummy copy of your workbook. Without more information, responses will be of limited help to you.