Results 1 to 3 of 3

Thread: Creating a Large Excel File - how large can i go?

  1. #1

    Creating a Large Excel File - how large can i go?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am creating a forecasting model. The excel file getting quite large (6.5MB). Is there a practical excel file size limit i need to be aware of? I don't want to keep adding functionality/features to the model if it will become unstable. I could move some data to a different file but i would prefer to keep the model totally self contained.

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,209
    Articles
    57
    Blog Entries
    14
    It depends a lot on your computer and it's processor, really. The bigger it gets, the more it will slow down.

    One thing to be aware of is that, depending on the version of Excel you're using, you may hit a memory limit. (Although I'm not 100% sure on this.) Office 2007 and earlier only came in 32bit versions, and I believe they could only access a maximum of 2GB of RAM. In Excel 2010 there was a 64bit version released, and that accesses much more.

    I have models that are almost 20MB and they still work fine, just slow is all.

    The only time I've crashed Excel due to memory issues is working with a 32bit version of Excel 2010 when I was running a PowerPivot model. We're talking several hundred thousand rows of data and I accidentally kicked off a circular evaluation. That brought it to it's knees. Ironically, in the 64bit version it is just peachy, as there is enough memory to work through my bad programming.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Hello, I've been working with a 33MB file and shared with another 10 users. The only problem is when you opened it the first time, then you can work without problems.

Posting Permissions

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