Hi Ally,

In the picture above, you do not have current year selected.

Kindly enter the year, it should automatically populate the figures for you.

If it doesn't, go to the Data tab and click on Refresh in the Excel workbook.

Thank you

Michael 

Hey Michael.

I have tried what you have suggested but still no results, I do still get the # values.

Thank you.

Chamumi Ally

Hi Ally,

Kindly take a picture of the report with the year entered.

Kindly select cell with the name of the company.

Thank you

Michael

Hi Ally,

Kindly take a picture of the report with the year entered.

Kindly select cell with the name of the company.

Thank you

Michael