File size problems

[Flashart]

Hi everyone

I have a workbook that houses 3 sets of data approx 30k x 12 columns in each of the sheets.

The overall file size for this is about 15.5mb. The first 11 columns have data dumped from a web query and the twelfth column houses a formula. This formula is then copied down however many rows is needed automatically by the web query.

When I take the formula out of all the rows the files size more than halves. However the formula is extremely handy as it enables me to select something quickly within a pivot. So I would rather keep it than get rid!

Is there anyway of creating a lookup for a formula? For example A1 has data, C1 has a formula. B1 looks at the formula in relation to to the data in A1 and returns the result.

The formula is

Please Login or Register  to view this content.

I am starting to think Macros but am trying to avoid if possible purely for simplicity!

many thanks

[romperstomper]

Have you tried creating a Name with that as the formula (make sure you have the right cell active since you are using relative addressing)? That should reduce your file size.