Excel Report - User needs to refresh data manually
We encounter the following issue, mail and deploy creates and sends xls report.
in the report there is an xls - pivot table that is refreshed when opening the file.
But we also have formulala's in the xls, and these are not refreshed.
When user receives the mail and opens the file, he first need to do a RefreshAll before formula's are showing the correct data.
XLS has been set for automatic calculation.
Any body an idea ?