VBA - very strange Pivot Table incompatibility? issue

[cacos]

Hi everyone, having a bit of a headache with this one, hopefuly someone out there has an idea.

I have a rather complex dashboard that's not working on a specific person's computer. It works fine on mine, as well as many other computers, but not on this other person's excel.

It's difficult because I can't recreate the error on my own PC, so by sharing screens I got to see that by debugging, the error appears in a line as simple as this:

ptable5.ClearAllFilters

Ptable5 was declared as Pivot table, and set accordingly. When I go to the Pivot Table to check, I doesn't even let me "Refresh" from the Excel menu, and an error message reads "Pivottable report is invalid, try refreshing the data". Which I tried, to no success.

So the question: Is there any logical explanation as to why a report that works perfectly fine in many different computers, is having this issue on a specific computer?

Note: It was made in Excel 2007, and the computer where it's failing runs 2010. Still, I ran it on a different computer also running 2010 and it worked just fine, so nothing there.

Thanks!

 

[SirJB7]

Hi, cacos!
If the data source is on other workbook or file that are in a network, have you checked that the user has the proper access rights to that file?
Regards!

 

[NARAYANK991]

Hi Lucas ,

Have you checked what is displayed when you click on Change Data Source ? Does the dialog box show the correct data range , or at least a valid range ?

Narayan

 

[cacos]

I'll check for the source now to see what comes up, apart from that is there any other reason related to network or permissions that you'd consider could affect it from working?

I'm going to check references as well, though there shouldn't be anything affecting pivots there.

@SIRJB, data source is in a tab inside the workbook, so no network connections at all.