You can't have two workbooks in view using split.

What you want is WindowNew Window

WindowArrangeVertical or whatever.

Now each workbook can be in its own window.


Gord Dibben MS Excel MVP

On Wed, 17 Oct 2007 03:08:03 -0700, Natanya Steyn <Natanya
wrote:

i would like to be able to work in both workbooks while using the split
windows funtion