Don't understand why am i getting error in some cells while others are responding fine.
in
Data Analysis with Excel Pivot Tables
/
GetPivotData is great! Extracting data from the Master Pivot Table
3 answers ( 0 marked as helpful)
Hi Muhammad Ali Jafri,
This will be a bit of a guess BUT another colleague had virtually the same errors you have shown. If this doesn't fix your errors, provide a screenshot of the formula in the 'error' cell and I will take another look.
If you are using the worksheets provided for the course, there is a 'spacer' row between Volume and Gross Sales Income, so $B7 references an empty cell. I suggest it should be $B8 - see if that works.
Regards,
Kev T.
That dose not seems to be the case, as for the rest of the cells i had to convert them from General to numbers, I have done the same with all of them but nothing seems to be working.