hi all,
i am creating a worksheet using microsoft excel 2007. This worksheet has values which are sourced from other excel files. e.g. customer returns 2011-2012. so i want to chart the corresponding values for each day through to 31 july 2012. but these files do not yet exist until created and saved by the user. however when setting up this workbook, i get a dialog box asking to update these values, to which i click cancel, but i have to click each one, so i must click around 1500 times. is there a way i can disable this, either with a macro or otherwise
thanks in advance
i am creating a worksheet using microsoft excel 2007. This worksheet has values which are sourced from other excel files. e.g. customer returns 2011-2012. so i want to chart the corresponding values for each day through to 31 july 2012. but these files do not yet exist until created and saved by the user. however when setting up this workbook, i get a dialog box asking to update these values, to which i click cancel, but i have to click each one, so i must click around 1500 times. is there a way i can disable this, either with a macro or otherwise
thanks in advance
