+ Reply to Thread
Results 1 to 2 of 2

Macro doesn't work on external source based pivot (on internal works correctly). Error 400

  1. #1
    Registered User
    Join Date
    12-14-2012
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    1

    Thumbs down Macro doesn't work on external source based pivot (on internal works correctly). Error 400

    Hi, I have macro which perfectly works on Excel 2010 (it filters values based on an external list). I tried the same on a different file on Excel 2013 but I get "400" error.
    Sheet and range names are 100% correct. No typo. Another difference is that in a second file I use external pivot source (not internal). Maybe that is the issue not Excel version? Is there any workaround?

    Please Login or Register  to view this content.
    I got "400" error, so I put this:
    Please Login or Register  to view this content.
    and I got:
    Unable to get the PivotFields property of the PivotTable class
    Is it possible that the root cause is external pivot source (external link to OLAP cube)?

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Macro doesn't work on external source based pivot (on internal works correctly). Error

    Hi shyha,

    Please go through http://www.excelforum.com/forum-rule...rum-rules.html and focus on p.8 : crossposting .
    The question has been originally posted here: http://www.excelforum.pl/topics3/mak...00-vt46604.htm
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 12-15-2014, 04:36 PM
  2. VBA pivot code doesn't work if the amount of source data becomes too large
    By punter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-28-2014, 07:59 PM
  3. Pivot Table Data Source - External to Internal
    By littlemy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-13-2014, 09:03 AM
  4. Macro that works on PC doesn't work on Mac.
    By elrader in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-09-2012, 03:52 PM
  5. Replies: 2
    Last Post: 02-22-2010, 08:21 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1