+ Reply to Thread
Results 1 to 2 of 2

Large Excel file- how can I make it run faster?

  1. #1
    Registered User
    Join Date
    07-13-2014
    Location
    columbus ohio
    MS-Off Ver
    2013
    Posts
    1

    Large Excel file- how can I make it run faster?

    Hello,

    I am a proficient Microsoft Excel user. I've recently joined a new company and am making a running file that contains historical sales data. The file, at this point, is 130,000 lines long and contains 26 columns of data (26 columns "wide" x 130,000 rows "long"). This file runs very slow and takes a long time to calculate.

    I have deleted out any formulas by copy/pasting values over the entire block of data. What other efforts can I make to help speed the processing time of this file? Again, it takes a very long time to open, and any changes made to the data put my newer computer on the verge of shutting down.

    Please help!

    Thanks,
    Georgia

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,341

    Re: Large Excel file- how can I make it run faster?

    Hi and welcome to the forum

    When I have had this kind of problem, I have put all the raw data in 1 file, and then run all the analsys in another file
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. [SOLVED] How to make excel file faster which uses option buttons?
    By hyperaura in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-26-2013, 01:16 PM
  2. Replies: 2
    Last Post: 01-16-2010, 09:27 AM
  3. Anyway to make Big file size and slow file small and faster
    By sa02000 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-26-2009, 04:22 PM
  4. Make excel run large spreadsheets faster
    By username22 in forum Excel General
    Replies: 1
    Last Post: 10-29-2005, 11:05 AM
  5. [SOLVED] How Can I make excel go faster
    By Jason Zischke in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-23-2005, 12:06 PM

Tags for this Thread

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