LinkBack URL
About LinkBacks
Hello. Is it bad to leave blanks for values in pivot table source data? Thanks.
Hello. Is it bad to leave blanks for values in pivot table source data? Thanks.
What is " bad" in your opinion?
What kuind of errors can it cause? Does excel count blanks or ignore them?
There is no cause for the same if you had a blank cell in you source data then it will happen. You can simple change the error and blank cells with 0.
Right click on Pivot -> Go to Pivot Table option -> Layout & format -> checkout format there is two options (1) For Error value show [] (2) For empty cell show []. Both cells fill with 0 or whatever you want and then click ok.
Hope this will help you
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks