Forum Discussion
constantinosk
Sep 19, 2024Copper Contributor
Spreadsheet integrity review
I have an Excel workbook with 15 sheets, 8334 cells with data, and 5851 formulas. Objective: Perform an integrity review, i.e. reviewing a spreadsheet to ensure that its data, formulas, and over...
- Sep 25, 2024
Patrick2788 That was very helpful; it worked. Thank you.
Patrick2788
Silver Contributor
I recommend trying Inquire's Workbook Analysis.
Here's some details on how to enable it (It's a Microsoft add-in) :
https://support.microsoft.com/en-us/office/analyze-a-workbook-with-spreadsheet-inquire-5991e8fa-f1c1-401a-ae3f-469384ae3e3b#:~:text=Start%20the%20workbook%20analysis%3A%201%20In%20Excel%2C%20click,range%20of%20cells%2C%20data%20connections%2C%20formulas%2C%20or%20errors.
Here's some details on how to enable it (It's a Microsoft add-in) :
https://support.microsoft.com/en-us/office/analyze-a-workbook-with-spreadsheet-inquire-5991e8fa-f1c1-401a-ae3f-469384ae3e3b#:~:text=Start%20the%20workbook%20analysis%3A%201%20In%20Excel%2C%20click,range%20of%20cells%2C%20data%20connections%2C%20formulas%2C%20or%20errors.
constantinosk
Sep 25, 2024Copper Contributor
Patrick2788 That was very helpful; it worked. Thank you.
- Patrick2788Sep 25, 2024Silver ContributorYou're welcome!