Umesh Manral is a data analyst and Excel automation specialist with 12+ years of experience. He publishes Excel walkthroughs on YouTube as @xlautomation.
YouTube, @xlautomation · LinkedIn
Tools
- See which parts make a workbook heavy
- Check a sheet that remembers empty rows
- Measure cached pivot records
- Count fragmented formatting rules
- Find formulas that recalculate too often
- Locate cached #REF! and #VALUE! cells
- List links to other workbooks
- Audit hidden and broken names
- Inventory macros without opening Excel
- Find sheets the Unhide box will not show
- Check a workbook Excel calls unreadable
Guides
- Why the file got large
- Reduce the file after you measure it
- Phantom rows and the last cell
- Causes of slow calculation
- A list of volatile functions
- Fix stored formula errors
- When Break Links does nothing
- Clean up defined names
- Very hidden sheets and VBA
- Is the XLSM safe to open?
- Repair unreadable Excel content