Hi Guys
Please can you assist with my attached file line 51 from my petty cash tab does not pull through on my pivot table tab.
Please help on how to fix.
Thanks Mellissa
Hi Guys
Please can you assist with my attached file line 51 from my petty cash tab does not pull through on my pivot table tab.
Please help on how to fix.
Thanks Mellissa
Your data source does not include row 51, hence the error. You need to change the data source of the pivot table. You can do so by selecting any cell on the pivot table >> go to analyze tab >> click change data source >> extend the range to include row 51.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
You have set the pivot table range to be
PETTYCASH!$A$20:$Q$50
so anything from row 51 onwards will be missed. Adjust it as required, or turn petty cash into a structured table.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi guys
Thank you for all your help it has worked.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks