error: excel cannot create or use data range reference ...

[edojan]

Hi

I get this error:

Microsoft Excel cannot create or use the data range reference because it is too complex. Try one or mroe of the following:

Use data that can be selected in one contiguous rectangle.
use data from the same sheet.

How do i fix this? this came up on 3 machines its a shared workbook on a network. I tried to open it at home and worked on home machine not at work ... none of the people who use it at work can open it same error message. Its on excel 2000 and has pivot tables ...

Thanks!