filmov
tv
Speed Up Excel Files With FastExcel Add-In

Показать описание
If a large, complex Excel file is very slow in calculating, it can be difficult to find and fix all the major trouble spots.
Instead of manually digging through the file, taking hours to check all the sheets and formulas, use the FastExcel add-in to find the worst trouble areas.
Just click a button, and a profile is created for the workbook, listing each sheet, sorted by calculation time.
Then, focus on the worst sheets, and click a button to locate the trouble areas on those sheets.
FastExcel gives you advice for fixing slow formulas, and has other tools to help speed things up.
This video shows you how to quickly analyze a workbook, and drill down into the worst areas.