Every time a dynamic worksheet or Pivot Table is refreshed, you’ll be authenticated with Dynamics 365 (online) using your credentials.
You’ll be able to see the data that you have permissions to view.
Having C2 as input parameter for the UDF in D2 tells Excel that it needs to reevaluate D2 everytime C2 changes (that is if auto-calculation of formulas is turned on for the workbook).In Excel 2007, 2010 or 2013, you can create a table to expand the data range, and the chart will update automatically. Select the data range and click Table under Insert tab, see screenshot:2.In the Create Table dialog box, if your data has headers, please check My table has headers option, then click OK. And the data range is formatted as a table, see screenshot:4. Whenever C2 changes value (actual value, not formula) I want to have the present date and time updated in D2.I have tried a lot of VBA codes and tricks and none of them works if a formula is entered in C2.