How can I make fixed a reference to a worksheet?

C

Consu

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

Many thanks in advance
 
P

Pete_UK

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
 
Top