I was trying to connect the pivot table through web on one of the users workstation. I wasn't receiving any error when I tried to access it from my machine or from the workstations in the IT dept.

But when I logged into the user's machine with my user name, it wasn't working. And ofcourse, whenever he logs in, it didn't work either.

I received the following error:

The PivotTable list 'PivotTable1' could not connect to the data source 'mycubename'.
For information about the data source, consult the creator of the file.

0x800a0bcd: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

Pls. someone help

Thanks a lot in advance,