Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #110562

Re: Pivot Table run-time error 1004 (PivotField class)

From GS <gs@v.invalid>
Newsgroups microsoft.public.excel.programming
Subject Re: Pivot Table run-time error 1004 (PivotField class)
Date 2018-04-08 16:08 -0400
Organization A noiseless patient Spider
Message-ID <padsrn$8ln$1@dont-email.me> (permalink)
References (4 earlier) <pa9458$db1$1@dont-email.me> <qiuhcdtp7lr2esma1sf6n4qu1sbrn1m9a4@4ax.com> <pab6dj$iti$1@dont-email.me> <668icdpnio2ckvctur04o8q8sm70mv83ic@4ax.com> <hslkcdtp7lr2esma1sf6n4qu1sbrn1m9ap@4ax.com>

Show all headers | View raw

> Just posting back on my findings.  I tried many of the variations that
> were in that link, and the closest I got was to actually get the pivot
> table to quickly filter on my catalog number variable.  However, it
> left the attached slicers untouched.  And several things I tried on
> the slicers worked, but every option took an inordinate amount of
> time.  That's presumably because of the 300+ pivot items the code is
> looping through.
>
> I'm able to use .ClearAllFilters to reset everything, so it would be
> nice if I was able to .AddAllFiltersExcept without doing a loop, but I
> don't think that exists.  It should, though, because there are about a
> zillion posts out there from people like me looking for something very
> similar.
>
> I think I've hit a dead end.  Any other thoughts or possibilities?
>
> Thanks Garry (and anyone else).
>
> Frank

I've never used PivotTables so perhaps a dumb Q here:

  Once you ClearAllFilters, can you not just add the one you want to use?

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Pivot Table run-time error 1004 (PivotField class) Phrank <pbeal@hotmail.com> - 2018-04-05 20:14 -0400
  Re: Pivot Table run-time error 1004 (PivotField class) GS <gs@v.invalid> - 2018-04-06 06:55 -0400
  Re: Pivot Table run-time error 1004 (PivotField class) GS <gs@v.invalid> - 2018-04-06 07:23 -0400
    Re: Pivot Table run-time error 1004 (PivotField class) GS <gs@v.invalid> - 2018-04-06 07:35 -0400
      Re: Pivot Table run-time error 1004 (PivotField class) Phrank <pbeal@hotmail.com> - 2018-04-06 20:13 -0400
        Re: Pivot Table run-time error 1004 (PivotField class) GS <gs@v.invalid> - 2018-04-06 20:42 -0400
          Re: Pivot Table run-time error 1004 (PivotField class) Phrank <pbeal@hotmail.com> - 2018-04-07 13:09 -0400
            Re: Pivot Table run-time error 1004 (PivotField class) GS <gs@v.invalid> - 2018-04-07 15:33 -0400
              Re: Pivot Table run-time error 1004 (PivotField class) Phrank <pbeal@hotmail.com> - 2018-04-07 15:52 -0400
                Re: Pivot Table run-time error 1004 (PivotField class) Phrank <pbeal@hotmail.com> - 2018-04-08 14:02 -0400
                Re: Pivot Table run-time error 1004 (PivotField class) GS <gs@v.invalid> - 2018-04-08 16:08 -0400
                Re: Pivot Table run-time error 1004 (PivotField class) Phrank <pbeal@hotmail.com> - 2018-04-09 06:34 -0400
                Re: Pivot Table run-time error 1004 (PivotField class) GS <gs@v.invalid> - 2018-04-09 16:29 -0400
                Re: Pivot Table run-time error 1004 (PivotField class) Phrank <pbeal@hotmail.com> - 2018-04-09 22:01 -0400
                Re: Pivot Table run-time error 1004 (PivotField class) GS <gs@v.invalid> - 2018-04-09 23:10 -0400
                Re: Pivot Table run-time error 1004 (PivotField class) GS <gs@v.invalid> - 2018-04-10 14:05 -0400
                Re: Pivot Table run-time error 1004 (PivotField class) Phrank <pbeal@hotmail.com> - 2018-04-10 22:10 -0400
                Re: Pivot Table run-time error 1004 (PivotField class) GS <gs@v.invalid> - 2018-04-11 00:03 -0400
                Re: Pivot Table run-time error 1004 (PivotField class) Phrank <pbeal@hotmail.com> - 2018-04-11 05:30 -0400
                Re: Pivot Table run-time error 1004 (PivotField class) GS <gs@v.invalid> - 2018-04-11 10:46 -0400
                Re: Pivot Table run-time error 1004 (PivotField class) Phrank <pbeal@hotmail.com> - 2018-04-14 09:09 -0400
                Re: Pivot Table run-time error 1004 (PivotField class) GS <gs@v.invalid> - 2018-04-14 13:58 -0400
                Re: Pivot Table run-time error 1004 (PivotField class) Phrank <pbeal@hotmail.com> - 2018-04-17 18:15 -0400
                Re: Pivot Table run-time error 1004 (PivotField class) GS <gs@v.invalid> - 2018-04-17 19:48 -0400

csiph-web