If you are unable to see that and you get access denied errors, make sure that the computer account has read\write permission to the system container in AD.Make sure the permission is flowing to the objects within and the objects below.
If it is not able to report properly, you need to make sure that the agent can communicate over the network to the site server successfully.
Is there some obscure setting that has been triggered in this file that is creating this issue? Neither F9 nor turning on Iterative Calculation made the cells in question update, but double-clicking the cell and pressing Enter did.
I searched the Excel Help and found this in the help article titled the ctrl alt f9 , is the temporary solution , going to options-formula-auto calculate is the right way, that option turned manual, because some shortcut key on being pressed by mistake turns automatic to manual VBA Excel function.
If that container has the stale records for the resources, then client records may be created for systems that don’t actually exist, thus they will never report.
There is a Maintenance task that will clear the inactive records but if the discovery process runs again and the AD container still has these entries then they will simply show up again.
This can be time consuming if other Excel files are loaded because all Excel sheets of all opened workbooks will be calculated again! Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).