Originally Posted by
CC
In terms of manual refresh or VBA, there is no functional difference - VBA is 'simple', it's not a bad understanding to think of many VBA methods as simply pressing the relevant buttons for you.
I think, however, that your problem is possibly a bit more simple. Defining a DNR is one thing, you then need to set the source of the pivot to that defined name. NB the default name inserted by the pivot table wizard will not be a named range (i.e. if your DNR, "myrange", evaluates to A3:C10 the PT wizard will propose the source A3:C10, which would need to be overwritten with "myrange").
CC
Thanks for the ideas. My application is basically a check register so I NEED to have the ability to have successive 'rows' added to the LIST. To that end, I created a DNR with this formula: =OFFSET(Sheet1!$A$4,0,0,COUNT(Sheet1!$A:$A),9) named Actual. (there are 9 columns) Next I went to my pivot table and ran the wizard, backedup, and inserted Actual as a name. I got "REFERENCE NOT VALID".
Also, when I goto a new row, XL takes about 20 seconds to 'reclaculate the PT'.... I don't think that is how it supposed to be. The only VB I have is this:
Here is the file: (I just figured out how to upload it) budget2.xls
Bookmarks