Excel pauses when formatting(ie inserting) and then restarts

Posted on 2011-05-09
Last Modified: 2013-12-11
When inserting or formatting in Excel the program pause from 30 seconds to a miinute and then works great?
Question by:rstcroix
    LVL 19

    Expert Comment

    that could be because of a number of reasons, such as :

    you are using a huge workbook or worksheet
    a macro is activated on running or formatting in excel
    your computer is low on memory or CPU power

    is it possible to post your workbook here ?

    Author Comment

    It also happens when creating a new workbook and the computer has 3gb of memory and i have checked cpu usage already. I haven't check for macros running.
    LVL 33

    Expert Comment

    The rest of your Office applications run OK? This only happens with Excel? Try switching to another default printer and check if the problem remains.
    LVL 19

    Accepted Solution

    That another point of concern indeed, as JPPinto indicates a faulty or missing network connection can very easily make for big delays.
    Could it be that the standard template you are using is stored on a network drive or mapped folder ?

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
    With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now