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

 

[jimmmi]

Any help please?

 

[jimmmi]

No one can help?

 

[jimmmi]

OK thank you all for the great help

 

[FormR]

disturbing message getting all the time

This response might be a little confusing for other readers as it relates to the original post that got deleted - but did you get that message when you first started using the template i.e. before you attempted to add code to do the automatic refresh?

 

[jimmmi]

This response might be a little confusing for other readers as it relates to the original post that got deleted - but did you get that message when you first started using the template i.e. before you attempted to add code to do the automatic refresh?

I am getting this message before and after the macro.
Same result asking yes or no and keep pressing yes.
Can i add a macro to just ignore it or auto press yes?

 

[jimmmi]

The chart takes the data from the hidden sheet which has the pivot.
The only problem is that the pivot sheet doesn't refresh automatically it's data when i change sheet

 

[FormR]

Not tested (I don't have the template) - but you could try these additions to the code.

Private Sub Worksheet_Activate()
Application.DisplayAlerts = False
ThisWorkbook.RefreshAll
Application.DisplayAlerts = True
End Sub

 

[jimmmi]

Not tested (I don't have the template) - but you could try these additions to the code.

Private Sub Worksheet_Activate()
Application.DisplayAlerts = False
ThisWorkbook.RefreshAll
Application.DisplayAlerts = True
End Sub

Thank you this did the job as i wanted.
Thank you very much

 

[jimmmi]

I have one more issue.
The graph shows blank where it's useless.
Can i hide this somehow?