Run time error - Pivot Cache Failed

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Run time error - Pivot Cache Failed

FAQ

Thread Tools

Display Modes

02-08-2016, 07:56 PM

patrick1063 patrick1063 is offline

Windows 10 Run time error - Pivot Cache Failed

Office 2013

Novice

Join Date: Feb 2016

Location: Brisbane

Posts: 1

Run time error - Pivot Cache Failed

Hi there,

Need assistance with this run time error:

'-2147417848 (800 10 108)':
Method 'Refresh' of object 'PivotCache' failed

Just by clicking on any of the slicers, this run time appears. Please need help to solve this.

The following line in highlighted in the debug:

Worksheets("Priority Areas").PivotTables("PivotTable5").PivotCache.Refr esh

File attached

Thanks in advance.

Regards,

Patrick

Attached Files

Excel file A.xlsm (47.9 KB, 7 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Get Run-time Error 11	Jamtart	PowerPoint	2	08-31-2012 05:04 AM
Run time error 1004	yonasan	Excel Programming	3	06-12-2012 11:08 PM
Word Visual Basic error - run time error 504	crazymorton	Word	11	01-13-2012 04:32 AM
Microsoft Office 2010 programs display error message "Application has failed to start	SamSR	Office	1	02-15-2011 07:15 AM
Run-time error 438	cksm4	Word	2	01-12-2011 03:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:04 PM.