General Programming question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

not bright - 27 Mar 2008 14:30 GMT

I have a 24meg excel file. I was wondering if using VBA can reduce the size
of the file and make the file calculate quicker?

Thanks

Reply to this Message

cht13er - 27 Mar 2008 14:51 GMT

On Mar 27, 9:30 am, not bright <notbri...@discussions.microsoft.com>
wrote:

> I have a 24meg excel file. I was wondering if using VBA can reduce the size
> of the file and make the file calculate quicker?
>
> Thanks

Most likely the file size is inflated somehow (layer upon layer of
conditional formatting is common) .. if you're able, open a new file,
copy over the data from each sheet, and save the new file ...

Without more specific reasons as to why the file is large and/or why
it's slow, it's unlikely you'll get much help here, sorry.

Chris

Reply to this Message

not bright - 27 Mar 2008 15:23 GMT

In the file I am working on (done by a co-woker) most of the cells use the
INDIRECT formula. The following is a sample from one cell:
=IF(INDIRECT(ADDRESS(B$2+3,12,,,"Types"))="","",IF(INDIRECT(ADDRESS($BP$7+($A6-1),$BQ$7,,,$BR$7))=INDIRECT(ADDRESS(B$2+3,12,,,"Types")),1,""))

There are about 12 tabs and about 8000+ cells in each tab. I'm just trying
streamline the file without have to break the file apart and have the main
file call another file to get the information.

> On Mar 27, 9:30 am, not bright <notbri...@discussions.microsoft.com>
> wrote:
[quoted text clipped - 11 lines]
>
> Chris

Reply to this Message