Run-time error....but only on 1 computer

[nulrichster]

I'm hoping that someone can help me crack this one - I have 2 computers setup to run reports in Excel, and the files used on my desktop have been copied directly into the same directory on my laptop.

On my desktop they run smooth, but if I run on the laptop it gives me the following error:

Run-time error '-2147417848 (80010108)':
Method 'CreatePivotTable' of object 'PivotCache' failed.

The highlighted error in the VBA:

Please Login or Register  to view this content.

Any ideas to how that can be...?

[DonkeyOte]

Presumably the Desktops are running an XL version prior to XL2007 - and the laptop ?
(XL2007+ utilises .Create rather than .Add I believe)

[nulrichster]

I used to have Office2003 on both of them, where I got the same error. The laptop is now running Office2007, but still without any difference

[DonkeyOte]

PivotCaches.Add does not exist in XL2007+ replaced by .Create which does not exist prior to XL2007.

[DonkeyOte]

edit: ignore that .. the .Add method will work in XL2007 apologies for misinformation

[DonkeyOte]

Can you outline how utvalg is declared ?
(if utvalg is valid range for ex. the code works for me in XL2007 without issue)

edit: also check you have no empty headers etc...

[Norie]

nulrichster

Is that all the code?

Have you tried breaking it down into adding the pivot cache and then creating the pivot table separately.

Please Login or Register  to view this content.

That might not solve the problem but it might give some more insight to what's happening.

One thing I did notice when testing that code was that both TableDestination and TableName could cause errors.

The latter errored when I tried specifying the destination and there was already a pivot table in that area.

The former basically when using the same name.

Both kind of obvious I suppose.