Excel: Transfer sheet with formulas intact

[krets]

I would like to move one sheet from an Excel workbook to another workbook with the formulas intact. The problem is that when I move the sheet the formulas within it still try to reference the old workbook instead of the new one it has been moved to.

The names of the other sheets in both workbooks are identical so what I'd like to happen is the formulas on the moved sheet to remain exactly as they are.

How can I do that?

 

[krets]

Oh, sorry. Using Excel 2003.

 

[krets]

And particularly it is the vlookups that are getting mucked up. The table arrays are still trying to reference the array in the old workbook.

 

[SkipVought]

Hi,

Eather than copying the SHEET, copy the DATA on the sheet to another workbook.

Skip,
[sub]
To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [/sub]