A simple little formatting setting in Excel can cause data to be hidden. If you enter three question marks under Format Cells . . . Number tab . . . Custom
. . . the data in the cells thus formatted with be invisible unless a user clicks in the cell.
The Payne Group's MetaData assistant can account for data which is hidden in this fashion.