Hello,

I use a workbook at work, using excel 2003, which uses the updatelink function to pull data from several password protected workbooks into one place. The workbook has a 'control' sheet and several 'tills'. On the control sheet, you click a button and it then pulls the data through from corresponding tills into this workbook.

This used to work well and without problems. Recently, however, the data that is being updated is being overlayed onto the control sheet, as well as to the relevant 'till' sheets.

Sorry if this doesnt make sense, but does anyone have any ideas as to why this might be happening?

Thanks.