A single file is also known as a Workbook.

A Workbook is comprised of Worksheets(tabs).

Are you confusing the terms?

Do you have just one workbook open with two worksheets?


Gord Dibben MS Excel MVP

On Tue, 20 Mar 2007 07:26:05 -0700, snakeinbenson
wrote:

I am working in an excel file with 2 tabs (2 workbooks). I cannot copy paste
between workbooks.

If I open a new file with 2 tabs the copy / paste between tabs works fine.

What setting in the existing file could be causing this. I am using Excel
2000.

Thanks !