Forum Discussion
Pivot tables
Hi,
jeffjm I am not sure what problem you have unless I see the file.
Riny_van_Eekelen this is a beginners' tutorial. That explains why the pace is slow for an advanced user ... When you create Public Tutorials you realize that you cannot make everyone happy (although I wish to). But anyway, I respect your opinion.
For the Named range I created, that's a Static named range, so it's normal to get a #REF when providing a Col_Index_number outside the range). There are other more advanced methods for creating a Floating named range, and SergeiBaklan (the Excel guru) can confirm that.
nabilmourad I had no problem with the pace. Just mentioned the time stamps so that the creation of "MyList" and the actual use of it could easily be traced.
Riny_van_Eekelen Please put me in touch with Nabil Mourad so I can chat with him about the pivot table and formula.
jeffjm You can respond to the post he made earlier or send him a private message. Hover the mouse pointer over his name tag and click "Message"
