Hi folks,

I have an application that generates spreadsheets. It is developed in
VB.NET 2003 and works well on XP with Excel 2003. Have tried to deploy
this on Windows Server 2000 with Excel 2000 only to get an error 'The
parameter is incorrect'. This error occurs on the follwing line:

ourPivotCache =
xlApp.ActiveWorkbook.PivotCaches.Add(SourceType:=x lDatabase,
SourceData:=rngData)

I don't think there is anything wrong with this line, bear in mind this
app works perfectly on XP against Excel 2003.

Now.. in an effort to fix this problem, I went and built this app on
the Windows 2000 server with VS .NET 2003 having changed the reference
to the Excel 9 library. Still no luck.

One thing worth noting here is that if I invoke Excel 2000 manually, a
message box appears with 'Cannot use object linking and embedding'. Is
this something to do with the problem, I don't know.

Anyone any ideas?