Mar 26

Excel 2013 very slow

Affected users: Global

Problem:

 Excel 2013 is very slow

  • When I copy and paste some data Excel is crashing and taking long time

  • Excel performance is really slow if I filter any data on the cell

Solution:-

Task 1: Increase your virtual memory

  1. Open the control panel > on the right hand top corner >Select view by “small icons”

  2. Select System> Advanced System Settings> Under Advanced> Performance> click Settings

Excel 2013 Slow_1

 

 

 3. Click Advanced > Virtual memory> Change

Excel 2013 Slow_2

 

 

 

 

 

 

 

5. Uncheck the “Automatically manage paging file size for all drives”

6. Click on C drive> Click custom size > Set Initial size as your RAM size Ex: If you have 6 Gig of RAM then it will be 1024*6=6144

7.On the Maximum Size> Double your RAM Size. In this case it will be 12240 . See below screen shot

 

 

Excel 2013 Slow_3

 

 

 

 

 

 

 

8. Click “Set” Button > Click > OK.  Then Reboot your machine to see the changes

 

 

 

 

 

 

 

 

 

Task 2: Changing your Excel 2013 settings

 

  1. Click File > Options> Advanced> Under Editing options> Uncheck the “Allow editing directly in cells” and “Automatically Flash Fill”

Excel 2013 Slow_4

 

  1. Click File > Options> Advanced> Under Display options > Click Disable Hardware graphics acceleration

Excel 2013 Slow_5

This will increase almost 67 % of improvements in Excel 2013

 

Tip: Always use Paste special values when you paste something on Excel

Please leave your comments below if this tip is useful

 

5 comments

Skip to comment form

    • Sagar on July 28, 2015 at 3:34 pm
    • Reply

    Worked like a charm! Thanks a lot for sharing!

    1. Glad it helped you.

    • Jindra Vavruska on August 31, 2015 at 10:31 am
    • Reply

    None of the above seems to be related to the slow response on Ctrl-C/Ctrl-V.

    I realized that slow response to Ctrl-C/Ctrl-V and related actions (such as “frozen” mouse selection after Ctrl-C) exhibits a typical pattern observed during network timeouts (unreachable services, SMB file server problems, etc.).

    That lead me to checking the status of each open Excel workbook and I realized that the slowdown occurs always when there is a (Excel) file opened from a “network” location (such as Windows share, or even temporary copy of Outlook attachment, etc.) which appears to be open in “protected view”. Obviously, the protected view schema brings in some strangely organized communication between processes in Excel, causing these freezes.

    • Tom R on September 26, 2015 at 7:23 pm
    • Reply

    I set all the Options you suggested above. Thanks… I am benchmarking an i5 4 proc 4GB against a i7 8 proc laptop 16GB. Basic formulas on i7 are about 40% faster… but when I use ‘Filter’ I have recalc times from sec to 10+ minutes… I can check a filter name box i.e. BD and it find 500 rows and takes just sec to recalc…. I select ALL and recalc in secs…. then chose the name right below the BD name i.e. Bismarck, find 10 rows and it takes 10-15 minutes to recalc… no idea why… this file is 130,000 rows by 40 columns.. I’ve Filter on Col 2 or Col 35 same results… I find rows in the 20,000s range and it takes 10 minutes and I find other Names in that same range and it takes sec.. when I find a name with 2 rows and there are in Rows 112,000 area the recalc just never stops… I have to close excel….

    yes I know I can turn off auto cal to manual. but why the big differences on the Filters? I can see them all taking the same time, but to go form sec to 10+ min makes no sense. I even turn on PowerPivot and that did nothing…..

    I removed 1 of the Columns that had a formula, same results…. I only have 1 other column that has a ‘MID’ formula..

    TIA Tom

    1. Hi Tom,

      Excel 2013 consider every window as a single instance and due to the shining graphics it is causing slow response.

Leave a Reply

Your email address will not be published.