+ Reply to Thread
Results 1 to 2 of 2

Handling large data sets in excel

  1. #1
    Registered User
    Join Date
    newcastle england
    MS-Off Ver

    Handling large data sets in excel

    I occasionally produce macros that produce large sets of results data (e.g. workbooks that are 100's MBs in size). My current strategy is to limit the size of the resultant workbooks to around 600MBs by breaking the resultant data set up in to separate workbooks as in the past I've experienced problems with excel when files are larger than this. for example not being able to save them.
    I have recently been thinking about learning how to store the data in a database e.g. in an access database created with ado or creating an sql database which I believe can handle even larger file sizes. Does this seem like a sensible way forward?

    Note, I am using 32bit excel, I believe that moving to 64bit excel may go someway to improve the size of the files excel can handle but I can't guarantee the version of excel that I'd be using at work.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)

    Re: Handling large data sets in excel


    That seems very sensible to me. I often store data in Access and then query it from Excel as and when needed- making sure to only pull in the data I need.
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. Dealing with large data sets in excel
    By stephme55 in forum Excel General
    Replies: 7
    Last Post: 02-01-2016, 04:30 PM
  2. Beginner needs guidance for large data handling
    By kappyb in forum Excel General
    Replies: 2
    Last Post: 03-21-2015, 08:22 AM
  3. My Excel Knowledge is very poor and working for large data sets in new job
    By mukeshsinha in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 10-21-2014, 05:20 PM
  4. Multiple crashes of Excel for Mac 2011 with large data sets
    By mskumar1512 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 07-29-2014, 08:40 PM
  5. Large Form Help: Handling large number of text boxes and labels
    By laterdaysluke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2010, 03:12 PM
  6. Replies: 1
    Last Post: 04-23-2006, 05:50 PM
  7. [SOLVED] how to save large data sets in excel
    By sheck in forum Excel General
    Replies: 1
    Last Post: 08-02-2005, 02:02 AM

Tags for this Thread


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