I don't have 2003 at the office any more, but I'll post back once I
try it back home.
On Dec 13, 11:08 am, James <Ja...@discussions.microsoft.com> wrote:
> Ok...I was trying to record a macro of creating a pivot table using the
> wizard, and it was not working. If I create the blank pivot table, and then
> drag and drop fields from the field list, it will record now. But, I am still
> getting some bug errors, but I think it is because I have too many rows in my
> source data. there are 16,000 rows, and if I decrease the number of rows that
> the pivot table is based on to under 10,000, it works. Sounds right? There is
> a 10,000 row limit? Oh...and the new company I am working for is using Excel
> 2003.
>
> "iliace" wrote:
> > Can you post the macro? Also, what version of Excel are you using?
>
> > On Dec 12, 11:00 am, James <Ja...@discussions.microsoft.com> wrote:
> > > I am trying to record a macro that creates a pivot table, and I am getting an
> > > error...I get a "run time error 1004: AddFields method of PivotTable class
> > > failed". I have lowered my security settings, selected to trust access to VBA
> > > project...any other suggestions?
>
> > > "iliace" wrote:
> > > > On Dec 11, 4:15 pm, James <Ja...@discussions.microsoft.com> wrote:
> > > > > Anyone know if you can use the "record macro" function to record the creation
> > > > > of a pivot table?
>
> > > > Absolutely. In fact, that's one of the best ways to figure out the
> > > > PivotCache and PivotTable objects.- Hide quoted text -
>
> > > - Show quoted text -
|
Similar Threads
