Hi Guys.
Is it possible to connect a scroll bar form control to a working pivot table?
Like you can still refresh the pivot table and all, but the rest of the table is scrollable.
I just want to know if this is actually possible.
I've already tried using the scroll bar but I use it with the offset formula.
So the pivot table isn't on the actual area with the scroll bar.
So I'm now pretty much stumped.
I'll be looking forward to your responses!
Thanks!
Is it possible to connect a scroll bar form control to a working pivot table?
Like you can still refresh the pivot table and all, but the rest of the table is scrollable.
I just want to know if this is actually possible.
I've already tried using the scroll bar but I use it with the offset formula.
So the pivot table isn't on the actual area with the scroll bar.
So I'm now pretty much stumped.
I'll be looking forward to your responses!
Thanks!