Excel doesn't have the Compact feature like Access does, but sometimes it
seems to need one.
Your file can grow quite large during use if you add lots of information to
one or more sheets in it and then delete the information without actually
deleting the rows and/or columns that it occupied. You can end up with what
looks like a relatively empty workbook that occupies megabytes of
memory/drive space.
Debra Delgleish has some helpful information on reducing the size of files
in those kinds of situations. See http://www.contextures.com/xlfaqApp.html#Unused
that has the seemingly unrelated title of
Why do my scrollbars go to row 500 -- my data ends in cell E50?
but it is spot on about this issue.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
