Benefits Of Using 64bit Office 2010 - Excel

Excel 2010 is available in a 64-bit version, which means that power users and analysts can create bigger, more complex workbooks. By using a 64-bit version, you can address physical memory (RAM) that is above the 2-gigabyte (GB) limit that exists in the 32-bit version of Excel. 

General improvements: Excel 2010 improves performance in a number of areas. For example, Excel 2010 is more responsive when you move and resize charts, work in Page Layout view, and interact with shapes on the worksheet.

Read more:Benefits Of Windows 7 64-bit Operating System.Performance improvements in Excel 2010 can help you to interact with your data more efficiently. Specific investments include:

Support for large data sets:

Excel 2010 handles workbooks that contain massive amounts of data more efficiently. Specifically, it takes less time to perform activities commonly performed on large data sets, such as filtering and sorting the data, copy and pasting it from one worksheet to another, and using the Fill feature to copy formulas.

Multicore improvements:

Multithreading improvements in Excel 2010 help to speed up the process of retrieving, sorting, and filtering data in PivotTables and Excel tables. In addition, opening and saving large files is generally faster than before.

Faster calculation:

If workbooks are critical to key business processes in your organization, it’s important that calculation speed doesn’t become a bottleneck. To achieve faster calculation performance, Excel 2010 includes support for asynchronous user-defined functions, which can run simultaneously without using multiple Excel calculation threads. This is valuable when you are importing data into worksheets in custom ways, and in high-performance computing (HPC) scenarios.