• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Resources - Excel 2007

M

mswenoflb

New Member
I notice that a large worksheet creates Excel resource errors at about 100 columns. Memory is not the culprit but rather Microsoft's sizing of stacks or heaps where pointers keep track of things is. I don't understand why Microsoft imposed this limit while expanding the spreadsheet rows and columnss!


Does anyone have any techiniques to work around this limitation?


Thanks,


Mark
 
Excel spreadsheets have at least 256 columns, and have had so at least as far back as Excel 2000.


Are you using a lot of array formulas or volatile functions?


Can you explain what errors are occurring?
 
You must log in or register to reply here.
Back
Top