Results 1 to 2 of 2

Thread: Convert from Table to Range -> Not Enough Memory

  1. #1

    Convert from Table to Range -> Not Enough Memory



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

    I created a table of my data so I could do some filtering, but it's making excel very slow so I'd like to remove the table and continue working with a normal spreadsheet. However, when I select the "convert to range" option on the Table menu, I get a "Not Enough Memory" message. I ran a clean up utility, but I read on the microsoft website that this is probably due to the source cell limit on excel. Is there a way to get around this?

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Is this a very large file? What kinds of formulas do you have in the table? Lots of volatile formulas e.g. OFFSET or INDIRECT? Can you upload a file with a few rows in it?

Posting Permissions

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