How can I make fixed a reference to a worksheet?
 

That when I paste the worksheet with references to different workbooks it
always make reference to the same worksheet.

Many thanks in advance

How can I make fixed a reference to a worksheet?
 

You need to include the full path (if the workbook file is not open)
and the filename before the sheet name, like this:

='full_path[filename.xls]Sheet1'!A1

Note the apostrophes - allows you to have spaces in any of those
names.

Hope this helps.

Pete

On Nov 11, 11:25*am, Consu wrote:
That when I paste the worksheet with references to different workbooks it
always make reference to the same worksheet.

Many thanks in advance