Need help with MS template Personal Expense Calculator about refresh issue

[jimmmi]

I am using the template from MS the Personal Expense Calculator, i like it with these categories and subcategories but i have an issue with the refresh.
First of all the dashboard isn't refreshing automatically when i click on the sheet and i have to refresh it manual, and second when i click refresh all from data tab.
First i want to find a way to autorefreshing the dashboard after inserting expenses and click the dashboard sheet,
and second to avoid clicking yes or no all the time. Just the graph to work flawlessly.
I hope some expert in excel give me some help.
Thank you in advance.
PS I attached a photo with the disturbing message getting all the time

 

[FormR]

The graph shows blank where it's useless.
Can i hide this somehow?

Hi, difficult to say to be honest - I don't have the template and the picture doesn't really help.

 

[jimmmi]

I mean that the blank shows in pivot table then shows in pivot chart.
Is there any way to hide it from pivot table?
And not with the filters because if i just use filter, when i use slicer the filter resets and then shows again.
I attached a photo from the pivot table to let you understand what i mean.(sorry for the file being Greek but options are the same)

 

[jimmmi]

Any help please?