Troubeshooting

Hi Sejal

Thank you for your question. One way of troubleshooting an Excel sheet is to turn on formula auditing. Go to Tools > Formula Auditing > Show formula audting toolbar

You can use the toolbar to help identify the source of data used in cells that contain formulas. It does this by drawing arrows from the data source to the cell that uses the data.

I hope this helps - do let us know if you have any questions.

Kind regards,
Andrew