+ Reply to Thread
Results 1 to 4 of 4

excel is too slow with large program

Hybrid View

  1. #1
    Registered User
    Join Date
    02-06-2008
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    71

    excel is too slow with large program

    program has 45 columns, 3,000 rows, 6,000 kb.
    I am using a new Lenovo windows 7 desktop.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: excel is too slow with large program

    Hi,

    That's not particularly large.

    What's more important is what is the workbook doing.
    Are there any macros running for instance?
    Are you using any array formulae?
    What do you mean by too slow? By whose standard.
    Are we talking several seconds or minutes to calculate
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    02-06-2008
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: excel is too slow with large program

    no macros, no array formulaes, slow, very slow, many many minutes.
    I have sent it to access and it works very much faster.
    thank you.

  4. #4
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: excel is too slow with large program

    Hi,

    Check whether your file has unused range or formatting on sheets.


    Regards,
    Paresh J
    Click on "* Add Reputation" as a way to say thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 10
    Last Post: 10-25-2012, 03:31 PM
  2. Large data....slow excel performance..!!
    By Aryaa Dixit in forum Excel General
    Replies: 9
    Last Post: 01-07-2009, 03:39 AM
  3. Extremely slow excel with charts containing large amounts of data
    By EmnaX in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-19-2007, 07:37 PM
  4. [SOLVED] Opening a large HTML document in Excel - slow
    By PJL-2005 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-14-2005, 06:50 AM
  5. [SOLVED] Excel slow to close file/program
    By Ken in forum Excel General
    Replies: 2
    Last Post: 04-23-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1