Al utilitzar els nostres serveis, acceptes l'ús que fem de les galetes per anàlisis, contingut personalitzat i publicitat. Més información
Salta al contingut principal
Microsoft
Servei tècnic de Microsoft
  • Windows
  • Surface
  • Xbox
      • Outlook
    • PCs & Devices
    • Entertainment
    • Business
      • .NET
      • Documentos de Microsoft
    • Other
    Inicia la sessió
    Servei tècnic de Microsoft

    Memory usage in the 32-bit edition of Excel 2013 and 2016

    Contingut proporcionat per Microsoft

    Contingut proporcionat per Microsoft

    S'aplica a: Excel 2013


    Symptoms


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

      error message

    Cause


    Although improvements in Office 2013/2016 did not significantly affect system requirements, Office 2013/2016 does use more available system resources than Office 2010 did. The limit of virtual address space for 32-bit editions of Windows-based applications is 2 gigabytes (GB). For Excel, this space is shared by the Excel application itself together with any add-ins that run in the same process. The size of the worksheet itself also affects the usage of virtual address space. 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. This situation results in the error message that is mentioned in the "Symptoms" section.

    Resolution


    Excel expert users who work with complex Excel worksheets can benefit from using the 64-bit edition of Office 2013/2016. This is because the 64-bit edition of Office does not impose hard limits on file size. Instead, workbook size is limited only by available memory and system resources. 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. (Worksheets smaller than 2 GB on disk might still contain enough data to occupy 2 GB or more of addressable memory.)

    The following options can help improve performance in Excel 2013/2016:
    • Excel users who regularly work with large, complex Excel worksheets may benefit from using the 64-bit edition of Office 2013 because 64-bit editions of Windows-based applications can address up to 8 terabytes (TB) of memory. Learn more about 64-bit editions of Office 2013.
    • The 2-GB limitation is per windows process instance of Excel. You can run multiple files in one instance. However, if the files are really large and have to be open, consider opening multiple instances for the other files. For information about limits that you may encounter, go to the following website:
      You cannot paste any attributes into a workbook in another instance of Excel
    • If you are running Windows 7 or Windows 2008, we suggest that you install Platform update for Windows 7 SP1 and Windows Server 2008 R2 SP1.
    • Test performance without COM add-ins. COM add-ins can use memory at the expense of the 2-GB limitation. For testing, disable COM add-ins, and then start Excel. If COM add-ins are causing the memory issue, contact your third-party vendor for an updated copy or a 64-bit version of the COM add-ins.
    • Disable hardware graphics acceleration. This shuts off animations. To do this, on the File menu, click Options, click Advanced, click Display, and then select Disable hardware graphics acceleration.
    • Change your workbook to streamline areas that use memory unnecessarily. For suggested changes, see the following Knowledge Base article:
      3070372 How to clean up an Excel 2013 workbook so that it uses less memory
    Note: 32-bit Excel 2016 will be enabled for Large Address Aware with update May 4, 2016 build number 16.0.6868.2060 for the O365 Current Channel subscribers. For more information on Large Address Aware Update click here.


    More Information


    You can use Process Explorer to check whether you are approaching the 2-GB limit in Excel. Consider anything over 1.75 GB as a maximum for the 32-bit edition of Excel. The column to focus is not there by default and can be added by Choosing View> Select Columns> Process Memory tab and clicking on Virtual Size.

    Before moving to a 64-bit version of Office, please review the information at this link:

    https://technet.microsoft.com/en-us/library/ee681792.aspx


    Other Resources

    2779852  How to Troubleshooting Available Resources errors in Excel
    https://support.microsoft.com/en-us/kb/2779852


    Última actualització: 10 des. 2017
    • Correu
    • Imprimeix
    Gràcies! Els teus comentaris ens ajuden a millorar l'experiència d'assistència tècnica.

    Novetats

    • Xbox One X
    • Xbox One S

    Store i assistència tècnica

    • Perfil del compte
    • Centre de baixades
    • Seguiment de comanda
    • Assistència tècnica

    Educació

    • Office 365 per a escoles

    Empresa

    • Cerca un proveïdor de solucions
    • Microsoft AppSource

    Desenvolupador

    • Microsoft Visual Studio
    • Xarxa de desenvolupadors
    • TechNet
    • Acadèmia virtual de Microsoft
    • Channel 9

    Companyia

    • Carreres professionals
    • Privadesa
    Català (català)
    • Terms of use
    • Privacy & cookies
    • Trademarks
    • © Microsoft 2018
    This site in other countries/regions
    Algérie - Français
    Argentina - Español
    Australia - English
    Belgique - Français
    België - Nederlands
    Bolivia - Español
    Bosna i Hercegovina - Hrvatski
    Brasil - Português
    Canada - English
    Canada - Français
    Chile - Español
    Colombia - Español
    Costa Rica - Español
    Crna Gora - Srpski
    Danmark - Dansk
    Deutschland - Deutsch
    Dominican Republic - Español
    Ecuador - Español
    Eesti - Eesti
    El Salvador - Español
    España - Español
    Estados Unidos - Español
    France - Français
    Guatemala - Español
    Hong Kong SAR - English
    Hrvatska - Hrvatski
    India - English
    Indonesia (Bahasa) - Bahasa
    Ireland - English
    Italia - Italiano
    Latvija - Latviešu
    Lietuva - Lietuvių
    Luxembourg - Français
    Magyarország - Magyar
    Malaysia - English
    Maroc - Français
    México - Español
    Nederland - Nederlands
    New Zealand - English
    Norge - Bokmål
    Panamá - Español
    Paraguay - Español
    Perú - Español
    Philippines - English
    Polska - Polski
    Portugal - Português
    Puerto Rico - Español
    România - Română
    Schweiz - Deutsch
    Singapore - English
    Slovenija - Slovenščina
    Slovensko - Slovenčina
    South Africa - English
    Srbija - Srpski
    Suisse - Français
    Suomi - Suomi
    Sverige - Svenska
    Tunisie - Français
    Türkiye - Türkçe
    United Kingdom - English
    United States - English
    Uruguay - Español
    Venezuela - Español
    Việt Nam - Tiếng việt
    Ísland - Íslenska
    Österreich - Deutsch
    Česká Republika - Čeština
    Ελλάδα - Ελληνικά
    България - Български
    Казахстан - Русский
    Россия - Русский
    Україна - Українська
    ישראל - עברית
    الإمارات العربية المتحدة - العربية
    المملكة العربية السعودية - العربية
    مصر - العربية
    भारत - हिंदी
    ไทย - ไทย
    中国 - 简体中文
    台灣 - 繁體中文
    日本 - 日本語
    香港特別行政區 - 繁體中文
    대한민국 - 한국어