Excel 效能:效能與限制改善Excel performance: Performance and limit improvements

適用於: Excel | Excel 2016 | Excel 2013 | Excel 2010 | Office 2016 | SharePoint Server 2010 | VBAApplies to: Excel | Excel 2016 | Excel 2013 | Excel 2010 | Office 2016 | SharePoint Server 2010 | VBA

Excel 2016 推出的新功能,可供您用來改善使用大型或複雜 Excel 活頁簿時的效能Excel 2016 introduces new features that you can use to improve performance when you are working with large or complex Excel workbooks

VLOOKUP、HLOOKUP、MATCH 改善VLOOKUP, HLOOKUP, MATCH improvements

在 Office 365 1809 版及更新版本中,Excel 針對未排序的資料進行完全符合的 VLOOKUP、HLOOKUP 和 MATCH,在查詢相同資料表範圍中的多個資料行 (使用 HLOOKUP 時為資料列) 時較以往的速度更快。In Office 365 version 1809 and later, Excel's VLOOKUP, HLOOKUP, and MATCH for exact match on unsorted data is much faster than ever before when looking up multiple columns (or rows with HLOOKUP) from the same table range.

這些查詢函數現在會為要搜尋的資料行範圍建立內部快取索引。These lookup functions now create an internal cached index for the column range being searched. 此快取索引會在從相同資料列 (VLOOKUP 和 MATCH) 或資料欄 (HLOOKUP) 提取的任何後續查詢中重複使用。This cached index is reused in any subsequent lookups that are pulling from the same row (VLOOKUP and MATCH) or column (HLOOKUP). 效果很明顯:對相同資料表範圍中 5 個不同資料行的查詢可能較使用 Excel 2010 或 Excel 2016 的相同查詢最高快 4 倍,而查詢愈多資料欄時改善愈大大。The effect is dramatic: lookups on 5 different columns in the same table range can be up to 4 times faster than the same lookups using Excel 2010 or Excel 2016, and the improvement is larger as more columns are looked up.

例如,使用 Excel 2010 來計算這 5 個 VLOOKUP 公式的 100 個資料列耗費了 37 秒來計算,而使用 Excel 2016 則只需要 12 秒。For example calculating 100 rows of these 5 VLOOKUP formulas took 37 seconds to calculate using Excel 2010 and only 12 seconds using Excel 2016.

=VLOOKUP($A900000,$A$2:$E$1000000,1,FALSE)
=VLOOKUP($A900000,$A$2:$E$1000000,2,FALSE)
=VLOOKUP($A900000,$A$2:$E$1000000,3,FALSE)
=VLOOKUP($A900000,$A$2:$E$1000000,4,FALSE)
=VLOOKUP($A900000,$A$2:$E$1000000,5,FALSE)

32 位元 Excel 的 LAA 記憶體改善LAA memory improvement for 32-bit Excel

雖然 64 位元版本 Excel 中有大量記憶體的限制,32 位元版本則只有 2 GB 的虛擬記憶體。Although the 64-bit version of Excel has large virtual memory limits, the 32-bit version has only 2 GBs of virtual memory. 有些客戶使用 32 位元版本,因為某些協力廠商增益集和控制項都無法在 64 位元版本中執行。Some customers use the 32-bit version because some third-party add-ins and controls are not available in the 64-bit version.

32 位元版本的 Excel 2013 和 Excel 2016 現在已啟用大量位址提示 (LAA)。The 32-bit versions of Excel 2013 and Excel 2016 now have Large Address Aware (LAA) enabled. 這會減少記憶體不足的錯誤訊息。This will minimize out-of-memory error messages.

LAA 可在 Windows 64 位元版本上將可用虛擬記憶體的數量從 2 GB 加倍至 4 GB,並在 Windows 32 位元版本上將可用虛擬記憶體的數量從 2 GB 增加至 3 GB。LAA doubles available virtual memory from 2 GB to 4 GB on 64-bit versions of Windows, and increases available virtual memory from 2 GB to 3 GB on 32-bit versions of Windows.

如需詳細資訊,請參閱 Excel 的大量位址提示功能變更For more information, see Large Address Aware Capability Change for Excel.

若要下載可顯示可用與已使用虛擬記憶體數量的工具,請參閱 Excel 記憶體檢查工具To download a tool that shows how much virtual memory is available and how much is being used, see Excel Memory Checking Tool.

整欄參考Full column references

在舊版 Excel 中,使用大量整欄參考和多個工作表的活頁簿 (例如 =COUNTIF(Sheet2!A:A,Sheet3!A1)),在開啟或在刪除資料列時,可能會使用大量記憶體和 CPU。In earlier versions of Excel, workbooks using large numbers of full column references and multiple worksheets (for example =COUNTIF(Sheet2!A:A,Sheet3!A1)) might use large amounts of memory and CPU when opened or when rows were deleted.

Excel 2016 組建 16.0.8212.1000 能減少在這些情況下使用的記憶體和 CPU。Excel 2016 Build 16.0.8212.1000 reduces the memory and CPU used in these circumstances.

在具有 6 百萬個公式的活頁簿的測試範例中,使用整欄參考失敗,出現記憶體不足訊息,在 Excel 2013 LAA 與 Excel 2010 使用了 4 GB 的虛擬記憶體,但在 Excel 2016 僅使用了 2 GB 的虛擬記憶體In a sample test on a workbook with 6 million formulas, using full column references failed with an out-of-memory message at 4 GB of virtual memory with Excel 2013 LAA and with Excel 2010, but only used 2 GB of virtual memory with Excel 2016.

結構化參考Structured references

在 Excel 2013 和較舊版本中,編輯活頁簿中的公式使用資料表結構化參考的資料表時很慢。In Excel 2013 and earlier versions, editing tables where formulas in the workbook use structured references to the table was slow. 這會讓您覺得不應對具有大量資料列的表格使用資料表。This led to the perception that tables should not be used with large numbers of rows. 在 Excel 2016 中不會再發生此問題。This issue no longer occurs in Excel 2016.

比方說,在 Excel 2013 與 Excel 2010 中耗費 1.9 秒的編輯作業,在 Excel 2016 大約為需要 2 毫秒的時間。For example, an editing operation that took 1.9 seconds in Excel 2013 and Excel 2010 took about 2 milliseconds in Excel 2016.

篩選、排序和複製/貼上Filtering, sorting, and copy/pasting

我們對在大型活頁簿中進行篩選、排序及複製/貼上的回應時間做了許多改善。We've made a number of improvements to the response time when filtering, sorting, and copy/pasting in large workbooks.

在 Excel 2013 中,篩選、排序或複製/貼上多個資料列後,Excel 可能回應會變慢,或是當機。In Excel 2013, after filtering, sorting, or copy/pasting many rows, Excel could be slow responding or would hang. 效能取決於介於上方可見列與下方可見列之間的所有資料列計數而定。Performance was dependent on the count of all rows between the top visible row and the bottom visible row. 在我們於組建 16.0.8431.2058 中改善了垂直使用者介面位置的內部計算之後,這些作業會快很多。These operations are much faster after we improved the internal calculation of vertical user interface positions in Build 16.0.8431.2058.

開啟具有多個篩選或隱藏資料列、合併的儲存格或外框的活頁簿時,可能造成高度的 CPU 負載。Opening a workbook with many filtered or hidden rows, merged cells, or outlines could cause high CPU load. 我們在組建 16.0.8229.1000 中推出這方面的修正。We introduced a fix in this area in Build 16.0.8229.1000.

從具有已篩選資料列的資料表貼上複製的儲存格資料行之後,導致大量的個別區塊資料列,回應時間很緩慢。After pasting a copied column of cells from a table with filtered rows where the filter resulted in a large number of separate blocks of rows, the response time was very slow. 這已於組建 16.0.8327.1000 中改善。This has been improved in Build 16.0.8327.1000.

從 44,000 個資料列篩選的 22,000 個資料列複製/貼上的測試範例可顯示大幅的改善:A sample test on copy/pasting 22,000 rows filtered from 44,000 rows showed a dramatic improvement:

  • 針對資料表,在 Excel 2013 中的時間耗費 39 秒、在 Excel 2010 中為 18 秒,到 Excel 2016 中為 2 秒。For a table, the time went from 39 seconds in Excel 2013 and 18 seconds in Excel 2010 to 2 seconds in Excel 2016.
  • 針對範圍,在 Excel 2013 中的時間耗費 30 秒、在 Excel 2010 中為 13 秒,到 Excel 2016 中則為一瞬間。For a range, the time went from 30 seconds in Excel 2013 and 13 seconds in Excel 2010 to instantaneous in Excel 2016.

複製條件化格式Copying conditional formats

在 Excel 2013 中,複製/貼上包含條件化格式的儲存格可能會很慢。In Excel 2013, copy/pasting cells containing conditional formats could be slow. 這在 Excel 2016 組建 16.0.8229.0 中已大幅改善。This has been significantly improved in Excel 2016 Build 16.0.8229.0.

複製具有總計 386,000 個條件化格式規則的 44,000 個儲存格的測試範例,可顯示實質上的改善:A sample test on copying 44,000 cells with a total of 386,000 conditional format rules showed a substantial improvement:

  • Excel 2010:70 秒Excel 2010: 70 seconds
  • Excel 2013:68 秒Excel 2013: 68 seconds
  • Excel 2016:7 秒Excel 2016: 7 seconds

新增及刪除工作表Adding and deleting worksheets

新增及刪除大量工作表時,Excel 2016 組建 16.0.8431.2058 的測試範例相較於 Excel 2013 會顯示 15% 到 20% 的速度改善,但較 Excel 2010 則低 5% - 10% 的速度。When adding and deleting large numbers of worksheets, a sample test on Excel 2016 Build 16.0.8431.2058 shows a 15%–20% improvement in speed compared to Excel 2013, but 5-10% slower than Excel 2010.

新函數New functions

Excel 2016 組建 16.0.7920.1000 推出幾個實用的工作表函數:Excel 2016 Build 16.0.7920.1000 introduces several useful worksheet functions:

  • MAXIFSMINIFS 延伸 COUNTIFS/SUMIFS 系列函數。MAXIFS and MINIFS extend the COUNTIFS/SUMIFS family of functions. 這些函數具有良好的效能特性。These functions have good performance characteristics. 使用它們來取代同等的陣列公式。Use them to replace equivalent array formulas.
  • TEXTJOINCONCAT 可讓您輕鬆地合併來自儲存格範圍的文字字串。TEXTJOIN and CONCAT let you easily combine text strings from ranges of cells. 使用它們來取代同等的 VBA UDF。Use them to replace equivalent VBA UDFs.

Windows 版 Excel 2016 的其他更新Other updates to Excel 2016 for Windows

如需有關 Excel 2016 按月付費之改善的詳細資訊,請參閱 Windows 版 Excel 2016 的新增功能For more details about the month-by-month improvements to Excel 2016, see What's new in Excel 2016 for Windows.

Excel 2010 效能改善Excel 2010 performance improvements

根據使用者對 Excel 2007 的意見回應,Excel 2010 推出對數項功能的改善。Based on user feedback about Excel 2007, Excel 2010 introduces improvements to several features.

功能Feature 改善Improvement
印表機和版面配置檢視Printer and page layout view
為了改善整頁模式檢視中基本使用者互動 (例如輸入資料、使用公式或設定邊界) 的效能,Excel 2010 會快取印表機設定,並推出最佳化的呈現計算。To improve performance of basic user interactions in page layout view, such as entering data, working with formulas or setting margins, Excel 2010 caches the printer settings and introduces optimized rendering calculations. 快取印表機設定可減少網路呼叫數目,並減少緩慢或未回應印表機的相依性。Caching the printer settings reduces the number of network calls and reduces the dependency on a slow or unresponsive printer. 此外,對印表機的連線也可取消,讓使用者不需要等待緩慢或未回應的印表機。In addition, connecting to the printer is cancelable so that the user does not have to wait for a slow or unresponsive printer.
圖表Charts
從 Excel 2010 開始,已增加圖表呈現的速度,特別是具有大型資料集的圖表,並且改善文字呈現的效能。Starting in Excel 2010, the rendering speed of charts has increased, especially with large data sets, and text-rendering performance has improved. 此外,Excel 2010 會快取圖表的影像,並且在可能時使用快取的版本,以避免不必要的計算和呈現。In addition, Excel 2010 caches an image of a chart and uses the cached version when possible, to avoid unnecessary calculations and rendering.
VBA 解決方案VBA solutions
與 Excel 2007 相較,在 Excel 2010 中執行時,對物件模型與其與 Excel 互動方式的改善,增加了許多 VBA 解決方案的效能速度。Improvements to the object model and the way it interacts with Excel increases the performance speed of many VBA solutions when run in Excel 2010 compared with Excel 2007.

大型資料集和 64 位元版本的 ExcelLarge data sets and the 64-bit version of Excel

64 位元版本 Excel 2010 不會像 32 位元版本應用程式受限於 2 GB 的 RAM,也不會像大量位址提示 32 位元版本應用程式受限於最多 4 GB 的 RAM。The 64-bit version of Excel 2010 is not constrained to 2 GB of RAM like the 32-bit version applications nor upto 4 GB of RAM like the Large Address Aware 32-bit version applications. 因此,64 位元版本 Excel 2010 可讓使用者建立更大型的活頁簿。Therefore, the 64-bit version of Excel 2010 enables users to create much larger workbooks. 64 位元版本 Windows 可啟用較大的可定址記憶體容量,並且 Excel 的設計可利用該容量。The 64-bit version of Windows enables a larger addressable memory capacity, and Excel is designed to take advantage of that capacity. 例如,使用者可較舊版 Excel 在格線中填入更多資料。For example, users are able to fill more of the grid with data than was possible in previous versions of Excel. 由於電腦新增更多的 RAM,Excel 會使用該額外的記憶體,因此隨著可用的 RAM 數量,可允許愈來愈大的活頁簿和規模。As more RAM is added to the computer, Excel uses that additional memory, allows larger and larger workbooks, and scales with the amount of RAM available.

此外,因為 64 位元版本的 Excel 可讓您使用較大的資料集,所以 32 位元和 64 位元版本的 Excel 2010 均推出對一般大型資料集工作的改善,例如輸入和向下填滿資料、排序、篩選,以及複製及貼上資料。In addition, because the 64-bit version of Excel enables larger data sets, both the 32-bit and 64-bit versions of Excel 2010 introduce improvements to common large data set tasks such as entering and filling down data, sorting, filtering, and copying and pasting data. 記憶體使用量也已最佳化,以在 32 位元和 64 位元版本 Excel 中變得更有效率。Memory usage is also optimized to be more efficient in both the 32-bit and 64-bit versions of Excel.

如需 64 位元版本 Office 2010 的詳細資訊,請參閱 32 位元和 64 位元版本 Office 2010 之間的相容性,而針對 64 位元和 32 位元之間的選擇,請參閱選擇 64 位元或 32 位元版的 OfficeFor more information about the 64-bit version of Office 2010, see Compatibility Between the 32-bit and 64-bit Versions of Office 2010 and for choosing between 64-bit and 32-bit, see Choose between the 64-bit or 32-bit version of Office.

圖案Shapes

Excel 2010 對 Excel 中圖形的效能推出大幅改善。Excel 2010 introduces significant improvements in the performance of graphics in Excel. 就高層級來說,這些改善可分為兩個方面:延展性和呈現。At a high level, these improvements are in two areas: scalability and rendering.

延展性改善對於工作表中包含數量龐大圖形的 Excel 案例有很大的影響。The scalability improvements have a large impact in Excel scenarios because of the large number of graphics contained on worksheets. 這個數量龐大的圖案通常是因為從網站複製並貼上資料,或是經常執行會建立圖案但不會移除圖案的自動化而不小心產生。Often, this large number of shapes is created accidentally by copying and pasting data from a website, or by commonly run automation that creates shapes, but never removes them. 這個數量龐大的圖案,結合圖形與 Excel 中資料格關聯的方式,代表的是數個獨特的效能挑戰。This large number of graphics, combined with the way that graphics relate to the data grid in Excel, presents several unique performance challenges. Excel 2010 中的改善可增加包含多個圖形的工作表的效能速度。Improvements in Excel 2010 increase the performance speed for worksheets that contain many shapes.

此外,從 Excel 2010 開始,對硬體加速的支援可改善呈現。In addition, starting in Excel 2010, support for hardware acceleration improves rendering. Excel 2010 也推出對 VBA 物件模型中 Shape 物件的 Select 方法的效能改善。Excel 2010 also introduces performance improvements to the Select method of the Shape object in the VBA object model.

功能Feature 改善Improvement
基本使用Basic use
對 Excel 2010 中所做的第一組改善是有關基本的使用案例。The first set of improvements made in Excel 2010 surrounds basic use scenarios. 這些案例包括作業和功能,例如排序、篩選、插入或調整資料列或資料欄的大小,或合併儲存格。These scenarios include operations and features such as sorting, filtering, inserting or resizing rows or columns, or merging cells. 在發生這些作業時,您可能需要更新格線上的圖形物件的位置。When these operations occur, it may be necessary to update the position of a graphic object on the grid. 在最差的情況下,必須對工作表上的每個單一物件進行更新。In the worst-case scenario, it is necessary to make an update to every single object on the worksheet. 在 Excel 2010 中,即使工作表上有數千個物件,也可以改善這些基本案例的效能。In Excel 2010, performance of these basic scenarios improves even when there are thousands of objects on the worksheet. 這些改善並非使用單一功能或修正而達成,而是透過專注於效能來達成,其中包括改善圖案的查詢機制、測試壓力檔案,以及調查阻礙。These improvements were not achieved with a single feature or fix, but through a dedicated focus on performance that included improving the shape lookup mechanism, testing stress files, and investigating obstructions.
文字連結Text links
當使用者指定可為指定圖案定義文字時的公式 (例如 "= A1") 時,即會在圖形上建立文字連結。A text link on a shape is created when the user specifies a formula, for example "=A1", that defines the text for a given shape. 這些特定圖形容易在具有大量物件的試算表上和/或在變更儲存格內容時造成效能問題。These particular shapes were prone to cause performance issues on sheets with a large number of objects and/or when changes were made to cell content. 從 Excel 2010 開始,Excel 追蹤及更新這些圖形的方式已經過改良,以將變更儲存格內容的效能最佳化。Starting in Excel 2010, the way Excel tracks and updates these shapes has improved to optimize performance for changing cell content. 這可改善案例,例如在儲存格中輸入新值,或是執行複雜的物件模型作業。This work improves scenarios such as typing a new value in a cell or performing complex object model operations.
大型格線Big Grid
從 Excel 2007 開始,格線的大小從 65,000 個資料列擴展到超過一百萬個資料列。Starting in Excel 2007, the size of the grid expanded from 65,000 rows to over one million rows. 此增加會造成在較大格線的新區域中使用圖形物件時的一些效能和呈現問題。This increase caused some performance and rendering issues when working with graphics objects in the new regions of the larger grid. 從 Excel 2010 開始,Excel 將仰賴於使用格線左上方做為起點的功能最佳化,以改善在格線的新區域中使用圖形的使用體驗。Starting in Excel 2010, Excel optimizes functionality that relies on using the top left of the grid as the origin to improve the experience of working with graphics in the new regions of the grid. 已改善有關 Excel 2007 的呈現逼真度與效能。Rendering fidelity and performance are improved relative to Excel 2007.
呈現:硬體加速Rendering: Hardware acceleration
從 Excel 2010 開始,透過新增呈現 3D 物件時對硬體加速的支援,對圖形平台進行改善。Starting in Excel 2010, improvements were made to the graphics platform by adding support for hardware acceleration when rendering 3-D objects. 雖然 GPU 呈現這些物件的速度比 CPU 快,在 Excel 2010 中的體驗取決於您的工作表上的內容。While the GPU can render these objects faster than the CPU, the experience in Excel 2010 depends on the content on your worksheet. 如果您有完整的 3D 圖形工作表,相較於僅具有 2D 圖形的工作表 (不會使用 GPU),您可以發現硬體加速改善有更大的優勢。If you have a sheet full of 3-D shapes, you will see more benefit from the hardware acceleration improvements than on a worksheet with only 2-D shapes (which do not leverage the GPU).

計算改善Calculation improvements

從 Excel 2007 開始,多執行緒計算已改善計算效能。Starting in Excel 2007, multithreaded calculation improved calculation performance.

從 Excel 2010 開始,已進行額外的效能改善,以便進一步增加計算速度。Starting in Excel 2010, additional performance improvements were made to further increase calculation speed. Excel 2010 可透過非同步方式呼叫使用者定義的函數。Excel 2010 can call user-defined functions asynchronously. 非同步呼叫函數藉由允許一次執行多個計算來改善效能。Calling functions asynchronously improves performance by allowing several calculations to run at the same time. 在計算叢集上執行使用者定義的函數時,非同步呼叫函數允許使用數部電腦來完成計算。When you run user-defined functions on a compute cluster, calling functions asynchronously enables several computers to be used to complete the calculations. 如需詳細資訊,請參閱非同步使用者定義函數For more information, see Asynchronous User-Defined Functions.

多核心處理程序Multi-core processing

Excel 2010 挹注了更多投資來利用多核心處理器的優勢,以及增加例行工作的效能。Excel 2010 made additional investments to take advantage of multi-core processors and increase performance for routine tasks. 從 Excel 2010 開始,下列功能會使用多核心處理器:儲存檔案、開啟檔案、重新整理樞紐分析表 (適用於外部資料來源,但 OLAP 和 SharePoint 除外)、將儲存格資料表排序、將樞紐分析表排序,以及自動調整欄大小。Starting in Excel 2010, the following features use multi-core processors: saving a file, opening a file, refreshing a PivotTable (for external data sources, except OLAP and SharePoint), sorting a cell table, sorting a PivotTable, and auto-sizing a column.

針對牽涉到讀取和載入或寫入資料的作業,例如開啟檔案、儲存檔案,或重新整理資料,將作業分割成兩個程序可增加執行速度。For operations that involve reading and loading or writing data, such as opening a file, saving a file, or refreshing data, splitting the operation into two processes increases performance speed. 第一個程序會取得資料,及第二個程序會將資料載入至記憶體中適當的結構,或將資料寫入檔案。The first process gets the data, and the second process loads the data into the appropriate structure in memory or writes the data to a file. 如此一來,在第一個程序開始讀取部分資料時,第二個程序即可以立即開始載入或寫入該資料,而第一個程序會繼續讀取下一個部分的資料。In this way, as soon as the first process begins reading a portion of data, the second process can immediately start loading or writing that data, while the first process continues to read the next portion of data. 在過去,第一個程序必須先完成讀取某些區段中的所有資料,第二個程序才能夠將該資料區段載入至記憶體或將資料寫入檔案。Previously, the first process had to finish reading all the data in a certain section before the second process could load that section of the data into memory or write the data to a file.

PowerPivotPowerPivot

PowerPivot 是指應用程式與服務的集合,其提供端對端的方法以在 Excel 活頁簿中建立資料驅動、使用者管理的商務智慧解決方案。PowerPivot refers to a collection of applications and services that provide an end-to-end approach for creating data-driven, user-managed business intelligence solutions in Excel workbooks. PowerPivot for Excel 是資料分析工具,可直接在 Excel 中提供無法倫比的運算能力。PowerPivot for Excel is a data analysis tool that delivers unmatched computational power directly within Excel. 使用者可以利用熟悉的 Excel 功能,將來自幾乎任何來源的大量資料,以令人讚嘆的速度轉換為有意義的資訊,以在幾秒內就獲得所需的解答。Leveraging familiar Excel features, users can transform large quantities of data from almost any source with amazing speed into meaningful information to get the answers they need in seconds.

PowerPivot 也已經與 SharePoint 整合。PowerPivot also integrates with SharePoint. 在 SharePoint 伺服器陣列中,PowerPivot for SharePoint 是一組伺服器端的應用程式、服務與功能的集合,其可支援商務智慧資料的小組共同作業。In a SharePoint farm, PowerPivot for SharePoint is the set of server-side applications, services, and features that support team collaboration on business intelligence data. SharePoint 提供用於在團隊與較大型組織之間共同作業和共用商務智慧的平台。SharePoint provides the platform for collaborating and sharing business intelligence across the team and larger organization. 活頁簿作者和擁有者會發佈和管理針對他們的 SharePoint 網站開發的商務智慧。Workbook authors and owners publish and manage the business intelligence that they develop to their SharePoint sites.

如需 PowerPivot 的詳細資訊,請參閱 PowerPivot 概觀For more information about PowerPivot, see PowerPivot Overview.

HPC Services for Excel 2010HPC Services for Excel 2010

Excel 2010 利用豐富的統計分析函數、支援建構複雜的分析,以及廣泛的擴充性,它是用於分析商務資料的工具選擇。With a wealth of statistical analysis functions, support for constructing complex analyses, and broad extensibility, Excel 2010 is the tool of choice for analyzing business data. 隨著模型變大,且活頁簿變得更複雜,產生之資訊的價值會增加。As models grow larger and workbooks become more complex, the value of the information generated increases. 不過,較複雜的活頁簿也需要較多時間來計算。However, more complex workbooks also require more time to calculate. 針對複雜的分析,使用者經常會花費數小時、數天,甚至數週來完成這類複雜的活頁簿。For complex analyses, it is common for users to spend hours, days, or even weeks completing such complex workbooks.

一個解決方案是使用 Windows HPC Server 2008 來平行在 Windows 高效能運算 (HPC) 叢集的多個節點間相應放大 Excel 計算。One solution is to use Windows HPC Server 2008 to scale out Excel calculations across multiple nodes in a Windows high-performance computing (HPC) cluster in parallel. 在以 Windows HPC Server 2008 為基礎的叢集中執行 Excel 2010 計算有三個方法:在叢集中執行 Excel 活頁簿、在叢集中執行 Excel 使用者定義的函數 (UDF),以及使用 Excel 做為叢集服務導向架構 (SOA) 用戶端。There are three methods for running Excel 2010 calculations in a Windows HPC Server 2008 based cluster: running Excel workbooks in a cluster, running Excel user-defined functions (UDFs) in a cluster, and using Excel as a cluster service-oriented architecture (SOA) client.

如需 HPC Services for Excel 2010 的詳細資訊,請參閱使用 Windows HPC Server 2008 R2 加速 Excel 2010For more information about HPC Services for Excel 2010, see Accelerating Excel 2010 with Windows HPC Server 2008 R2.

總結Conclusion

Excel 2016 推出的效能和限制的改善,著重於增加 Excel 有效率地處理大型且複雜活頁簿的能力。Excel 2016 introduces performance and limitation improvements focused on increasing Excel's ability to efficiently handle large and complex workbooks. 這些改善可讓 Excel 隨著硬體擴展,隨著電腦的 CPU 和 RAM 容量擴充而改善效能。These improvements allow Excel to scale along with hardware, improving performance as the CPU and RAM capacity of computers expand.

請參閱See also

支援和意見反應Support and feedback

有關於 Office VBA 或這份文件的問題或意見反應嗎?Have questions or feedback about Office VBA or this documentation? 如需取得支援服務並提供意見反應的相關指導,請參閱 Office VBA 支援與意見反應Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.