(Worksheets smaller than 2 GB on disk might still contain enough data to occupy 2 GB or more of addressable memory.) On the other hand, the 32-bit edition of Office is limited to 2 GB of virtual address space, and this space is shared by Excel, the workbook, and add-ins that run in the same process.

Instead, workbook size is limited only by available memory and system resources. This is because the 64-bit edition of Office does not impose hard limits on file size. ResolutionĮxcel expert users who work with complex Excel worksheets can benefit from using the 64-bit edition of Office 2013/2016. This situation results in the error message that is mentioned in the 'Symptoms' section. Because Excel loads the worksheet into addressable memory, some worksheets that have a file size of less than 2 GB may still require Excel to use more than 2 GB of addressable memory. The size of the worksheet itself also affects the usage of virtual address space. For Excel, this space is shared by the Excel application itself together with any add-ins that run in the same process. The limit of virtual address space for 32-bit editions of Windows-based applications is 2 gigabytes (GB).

Using a 64-bit version of Microsoft Excel.Īlthough improvements in Office 2013/2016 did not significantly affect system requirements, Office 2013/2016 does use more available system resources than Office 2010 did. To increase memory availability, consider: Try using less data or closing other applications. When you are working with an Excel worksheet, you receive the following error message: There isn't enough memory to complete this action. When you insert columns in an Excel workbook, you receive an error about available memory. You can no longer open as many Excel workbooks in the same instance as you could before you upgraded to Excel. The computer uses more memory when you open multiple Microsoft Excel files, save Excel files, or make calculations in Excel workbooks. After you upgrade to Microsoft Office 2013 or 2016, you experience one or more of the following symptoms:

Ms office 2013 32 bit