Xlsm slow file office 365

Question

Hi,

I installed yesterday office 365.

I usually worked with a xlsm file on Excel 2010.

Now working on excel 2013 (from office 365) this file is very slow.

Can you help me to solve this problema ?

Answer 1

Hi, Pedro! How are you doing?

Thanks for posting your questions at Microsoft Community!

The .xlms files works with macros and for this reason it might be slowing down. You have to check if is there any problem with third developer´s add-ins. I mean, this is not a Microsoft´s responsability.

To solve this issue, make the following procedure:

Starting an Office application in the Safe mode

1. Exit any running Office programs.
2. To start your Office application in Safe Mode, click Start > All Programs> Accessories > Run in Windows 7, go to your Start screenin Windows 8, type one of the following commands:
   • Type: excel /safeand press Enter to start Excel 2013
3. If the Office program runs normally, continue on to the next section: Disabling the ABBYY FineReader add-in".

If the Office application doesn’t start in Safe Mode, the add-in is not causing a problem.

Disabling the ABBYY FineReader add-in

1. Keep the Office application running in the Safe Mode.
2. Click File > Options > Add-Ins.
3. Next to the Manage list, click Go.
4. Uncheck the ABBYY FineReader add-in and click OK.
5. Restart the application (not in Safe Mode this time).

If the Office application starts, the add-in is causing the problem. Visit the ABBYY FineReader website to find out if there’s an updated version you can install. If there isn’t a newer version or if you don’t need to use the add-in you can leave it unchecked or remove it from your PC.

If the Office application doesn’t start, the problem isn’t related to the add-in. Go to the Need more help? section to learn about other reasons why this may happen.

Advanced Registry editing for Abby FineReader

If the FineReader add-in is causing an Office program to crash, you may see an event in the Application log that has the following parameters:

Event ID: 1000

Faulting module name: FRIntegration.dll

Event ID: 1000

Faulting module name: SprintIntegration.dll

Note: Even if you do not see one of these events, you may still encounter crashes because of this add-in

This portion of the article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Here's how:

How to Backup and Restore your Registry

1. Click Start > Run in Windows 7 or earlier, go to your Start screen in Windows 8, type regedit and press Enter.
2. Click Yes to start the Registry editor.
3. To backup: Under File, click Export.

To restore: Under file, click Importto restore a previously backed up Registry. 4. To backup: Select the folder where you want the backup file saved, type in the name of your choice and click Save.

To restore: Navigate to a previously backed up Registry file, highlight it and click Opento restore it.

Warning: Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

1. Exit any running Office programs.
2. Start your registry editor. Click Start > Run in Windows 7 or earlier; go to your Start screenin Windows 8, type regedit and press Enter.
3. Locate and then select the following key that matches the Office program that is crashing. See Key List below:
   • Microsoft Word

HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Word\Addins

Note: If you are using a 32-bit version of Office on a 64-bit version of Windows, you will need to select the following key:

HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\Office\Word\Addins - Microsoft Outlook

HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Outlook\Addins

Note: If you are using a 32-bit version of Office on a 64-bit version of Windows, you will need to select the following key:

HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\Office\Outlook\Addins - Microsoft Excel

HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Excel\Addins

Note: If you are using a 32-bit version of Office on a 64-bit version of Windows, you will need to select the following key:

HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\Office\Excel\Addins

1. Expand the \Addinssubkey to display all of the add-ins registered at the Machine level.
2. If listed, select the subkey for the FineReader add-in. See Subkey list below:

FineReader version 11**** - Microsoft Word

FRComAddInMSWORD11.FRComAddInMSWORD.1 - Microsoft Outlook

FRComAddInMSOUTLOOK11.FRComAddInMSOUTLOOK11.1 - Microsoft Excel

FRComAddInMSEXCEL11.FRComAddInMSEXCEL11.1

FineReader version 10
- Microsoft Word

FRComAddInMSWORD10.FRComAddInMSWORD.1 - Microsoft Outlook

FRComAddInMSOUTLOOK10.FRComAddInMSOUTLOOK10.1 - Microsoft Excel

FRComAddInMSEXCEL10.FRComAddInMSEXCEL10.1

FineReader version 9
- Microsoft Word

---

Sprint.WordIntegration.9 - Microsoft Outlook

Sprint.OutlookIntegration.9 - Microsoft Excel

---

Sprint.ExcelIntegration.9 3. Right-click the LoadBehavior value and then clickModify. 4. Change the Value datato 2, and then click OK. 5. Close Registry Editor. 6. Start your Office program that was crashing to determine if the registry change has improved the stability of the program.

If the crashing problem has stopped, we recommend you visit the ABBYY FineReader website. There may be a product update available that eliminates this incompatibility.

This procedure must solve this issue. If you need more informations, please, let us know posting again with more informations.

Best regards!

Answer 2

Olá, Pedro.

Sua pasta de trabalho contém macros? Gráficos? Autoformas?

O que demora na pasta de trabalho? Para abrir, para recalcular ou para simplesmente operar a planilha?