+ Reply to Thread
Results 1 to 4 of 4

UDF .Volatile results to #Value! error

  1. #1
    Registered User
    Join Date
    04-20-2012
    Location
    DeptLand
    MS-Off Ver
    Excel 2007
    Posts
    2

    UDF .Volatile results to #Value! error

    I got this code (from somewhere, maybe here) that returns the items selected on a pivot filter.

    Please Login or Register  to view this content.
    UDF works fine, it recalculates when I change the filter and when I refresh the pivot BUT I also have a macro initiated by a button that refreshes the pivot (pivot is somewhat hidden, that is why I need the button). The macro is simply:
    Please Login or Register  to view this content.
    SO, when I refresh the pivot via the button i get a #Value! error. If I reculc (full or F2 enter on one of the cells containing the UDF) it works fine again.
    Can anyone please explain, resolve?

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: UDF .Volatile results to #Value! error

    maybe
    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: UDF .Volatile results to #Value! error

    hi MONKgr, It looks that while refreshing pivot from VB the function can not get pivot table parameters . Try the following instead:

    Please Login or Register  to view this content.
    Last edited by watersev; 04-20-2012 at 08:06 AM.

  4. #4
    Registered User
    Join Date
    04-20-2012
    Location
    DeptLand
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: UDF .Volatile results to #Value! error

    thanks guys will try monday (other project got in the way)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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