fastexcel_使用FastExcel工具修复慢的Excel文件

fastexcel

If we're sitting at home, with little to do but eat, watch TV and sleep, we might get a bit slow and bloated, which isn't a great feeling. Nobody wants slow, bloated Excel files either, so Charles Williams just released a new, improved version of his FastExcel tools, to help you fix them! Unfortunately, it only works on Excel files, not people.

如果我们坐在家里，除了吃东西，看电视和睡觉而无所事事，我们可能会变得有点缓慢和肿，这不是一种很好的感觉。 也没有人希望缓慢而肿的Excel文件，因此Charles Williams刚刚发布了他的FastExcel工具的改进的新版本，以帮助您修复它们！ 不幸的是，它仅适用于Excel文件，不适用于人员。

什么是FastExcel？ (What is FastExcel?)

Maybe you haven't heard about FastExcel before. It's a set of tools that help you:

也许您以前从未听说过FastExcel。 这是一组可以帮助您的工具：

• build, debug and maintain Excel workbooks
  生成，调试和维护Excel工作簿
• finding and prioritising calculation and VBA bottlenecks
  查找并确定计算和VBA瓶颈的优先级
• speed up your Excel Calculations
  加快您的Excel计算

The previous versions of FastExcel were great, and Charles has spent years working on FastExcel V4, to make it even better.

FastExcel的早期版本很棒，Charles花了多年的时间来研究FastExcel V4，以使其变得更好。

视频：FastExcel演示 (Video: FastExcel Demo)

In this short demo video, you'll the one-click Drilldown command – it's a new feature in FastExcel V4.

在这个简短的演示视频中，您将一键单击“向下钻取”命令-这是FastExcel V4中的一项新功能。

The Drilldown quickly made a profile of my workbook, and found the worst worksheets, and the worst formulas on those sheets. Who made all those errors?

“向下钻取”功能Swift对我的工作簿进行了介绍，并找到了最差的工作表以及这些表上最差的公式。 谁犯了所有这些错误？

演示地址

您需要FastExcel吗？ (Do You Need FastExcel?)

If you're an Excel power user, with lots of calculation-intensive workbooks, the tools in Charles Williams' FastExcel add-in can help you in several ways:

如果您是Excel的高级用户 ，并且拥有大量计算密集型工作簿，那么Charles Williams的FastExcel加载项中的工具可以通过多种方式为您提供帮助：

• help make your Excel files calculate faster
  帮助您更快地计算Excel文件
• pinpoint calculation problems
  精确计算问题
• solve speed issues
  解决速度问题
• manage your workbooks
  管理您的工作簿

不适合所有人 (Not For Everybody)

FastExcel is not for everyone though. You don't need FastExcel if:

FastExcel 并非适合所有人 。 在以下情况下，您不需要FastExcel：

• you're a casual Excel user
  您是休闲Excel用户
• you only create simple Excel files
  您只创建简单的Excel文件
• you don't have problems with calculation speed in your workbooks
  您的工作簿中的计算速度没有问题

FastExcel-3个产品 (FastExcel - 3 Products)

There are 3 products in the FastExcel line, and you can get them separately, or in a bundle.

FastExcel系列中有3种产品，您可以单独购买或捆绑购买。

1. Profiler
   探查器
2. Manager
   经理
3. SpeedTools
   SpeedTools

FastExcel Profiler (FastExcel Profiler)

If you're tired of waiting for Excel to calculate, the Profiler tools can help you identify the reasons for the slow calculation.

如果您厌倦了等待Excel进行计算，则探查器工具可以帮助您确定计算缓慢的原因。

The Profiler has tools in 3 categories

探查器具有3类工具

• Calculation Profiler
  计算分析器
• VBA Profiler
  VBA探查器
• Calculation Manager
  计算经理

The new DrillDown Profiler is my favourite tool on this tab! If you watched the video (above), you saw me using it in one of my files.

新的DrillDown Profiler是该选项卡上我最喜欢的工具！ 如果您观看了视频(上图)，则看到我在其中一个文件中使用它。

FastExcel管理器 (FastExcel Manager)

FastExcel Manager has tools to help you build, debug and maintain your Excel workbooks.

FastExcel Manager具有可帮助您构建，调试和维护Excel工作簿的工具。

For example:

例如：

• Clean Workbook - Trim the bloat in your workbooks

  清洁工作簿 -修剪工作簿中的膨胀

• Name Manager Pro – Shows you things that the build-in Name Manager doesn't show!

  名称管理器专业版 -向您显示内置名称管理器不显示的内容！

• Formula Explorer - Edit / debug / explorer worksheet formulas

  Formula Explorer-编辑/调试/资源管理器工作表公式

Here's a screen shot of the Formula Explorer - it makes formula editing much easier!

这是Formula Explorer的屏幕截图-它使公式编辑更加容易！

FastExcel SpeedTools (FastExcel SpeedTools)

The SpeedTools product has tools and functions to help you speed up your Excel calculations. For example:

SpeedTools产品具有可帮助您加快Excel计算速度的工具和功能。 例如：

• Only calculate the active workbook
  仅计算活动工作簿
• Mix Automatic and Manual calculation by worksheet.
  通过工作表混合自动和手动计算。
• Control Workbook Open calculation methods.
  控制工作簿打开计算方法。

Here is a screen shot of the commands on the SpeedTools tab.

这是SpeedTools选项卡上命令的屏幕截图。

获得FastExcel捆绑折扣 (Get the FastExcel Bundle Discount)

If you decide to buy the FastExcel tools, take advantage of the bundle discount that's only available until Wednesday, April 15th, 2020.

如果您决定购买FastExcel工具，请利用仅在2020年4月15日(星期三)之前可用的捆绑折扣。

• NOTE: Use coupon code FXLV4INTRO to get a 40% discount when you buy the FastExcel bundle

  注意 ：购买FastExcel捆绑包时，使用优惠券代码FXLV4INTRO可获得40％的折扣

Click here to buy FastExcel V4 products or bundles, or get the 15-day trial version.

单击此处购买FastExcel V4产品或捆绑包 ，或获得15天的试用版。

翻译自: https://contexturesblog.com/archives/2020/04/09/fix-slow-excel-files-with-fastexcel-tools/

fastexcel