Hi all,
I have a dynamic pivot table using the following: =OFFSET(DATA!$A$3,0,0,COUNTA(DATA!$A:$A),COUNTA(DATA!$3:$3))
For some reason it is not picking up the very last line which is making some of the calculations wrong.
Does anyone have any idea what is causing this?
Thanks
Neil
I'd guess you have a blank cell in column A somewhere. I'd suggest you use a Table unless you have a particular reason for avoiding it.
Rory
Rorya,
Thanks for the quick reply....
I had already checked for that but that isnt the cause.
Im not sure what you mean when you say to use a table.
Neil
If you set your range up as a Table, you can use that as the source for the pivot. It will automatically include all data in the table as it grows.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks