Report Errors in Cell History

Glenn Riese

I have a report that goes out daily showing which items are past due.  The report is generated based a column that creates a flag when the line item is past due.  On Monday the report went out but says that some one made the change to the cell according to the cell history.  The report also looks the receivers that it came from this other user.  I have checked with the other user and she has not made any changes.  I have seen this happen a few times before.  Any thoughts on what is happening?

Mike Wilday

I would have to ask the following question: 

Does the flag get triggered when someone opens up a sheet on the day the items is past due? The changing of the flag may indicate that specific user because they are the one who opened the sheet and therefore triggered the formula that changed the flag.

You may want to test that scenario.