Bug with multiple workbooks open

Question

When I have multiple workbooks open in Excel 2013 (Windows 7 Professional), quite often the program seems to "freeze" and can only be resolved if I minimize all the workbooks and go back to the workbook I was trying to use.   It appears that the cursor jumps to another opened workbook.   Anyway to fix this?

Answer 1

Try following -

1. Please try to repair your Office as a quick fix.

http://office.microsoft.com/en-gb/excel-help/repair-office-programs-HA010357402.aspx

2. Please look into C:\Users\User_Name\AppData\Roaming\Microsoft\Excel (replace user name with your user name, you can directly reach here by copy and pasting following without quotes in Explorer address bar - "%appdata%\Microsoft\Excel\XLSTART") and see if is contains few files / folders. Move those files to some other location (i.e create a backup of those files / folders and delete all files / folders from here). Hence, make Excel folder blank.

Now open the file and see if the problem disappears or not. 

Note - to find Excel path, you need to find XLSTART path. Excel folder contains XLSTART folder in itself (In case, your XLSTART path is not in Appdata)

1. Open Excel
2. ALT+F11
3. If Immediate Window is not visible, type CTRL+G. Same can be also be accessed through View > Immediate Window
4. Type "? application.StartupPath" without quotes and press enter
5. You will have your path below.
6. Sometimes, this is caused due to excel not being able to access the default printer. Close all office applications and change your default printer through Start > Devices and Printers to another printer. It may be some physical one or One Note or XPS or PDF or anything else. If this is the problem, then you will need to update your printer driver for default printer.
7. Many third party applications also cause the problem like Tuneup Utilities, Abby Finereader, Kaspersky Anti Virus  etc. See if you have any of them installed. Close them one by one and see whether it helps.
8. Start the computer in clean boot and then try to access the Office applications, check the result.

Refer to the link below to know how to start the computer in clean boot:

http://support.microsoft.com/kb/929135

Note: Ensure to restart the computer in normal mode once troubleshooting is completed.

Clean boot is performed to disable all startup programs and 3rd party services on the machine and check if they are conflicting with the Office program. If so, you may disable the unwanted software those conflict with the suite or get them updated.

6. Sometimes, add-ins can cause problems. To determine, if add-in is a problem start Excel in safe mode and see if problem has gone away. If yes, then start Excel normally and disable add-ins one by one and start Excel again every time you disable an add-in to determine the culprit add-in.

To start Excel in Safe Mode -

Hold CTRL key and click on Excel icon

OR

In the Search Box above Windows icon, type "Excel /s" without quotes and enter.

7. File > Options > Advanced - In General section (go very much down in Advanced), check "Ignore Other applications that use Dynamic Data Exchange (DDE)". Close and re-start the Excel. Uncheck "Ignore Other applications that use Dynamic Data Exchange (DDE)". Close and re-start Excel again. You should not get the error anymore. (Basically, DDE should remain unchecked)
8. You may try to disable the Hardware Graphic Acceleration and verify the result:

    Open Excel.

    Click on file, Options.

    Go to the Advanced tab.

    Under the Display section, check the box for 'Disable hardware graphics acceleration'.

    Click ok and restart Excel.

9. Login to Windows with a new user profile and see if problem is resolved.

Answer 2

That didnt help

Answer 3

Hello,

There are several reasons as to why Office programs experienced errors. For us to determine and troubleshoot these errors, we recommend that you run OffCAT (Office Configuration Analyzer Tool) to your computer. You may refer to this support **link**for the steps.

Update us with the result so we can further assist you.