hi, i would like to get your advice regarding a problem i have with a big file.
i have a big file that exist alot of sheets with vlookups and formulas
between them.
one of the sheet is the heaviest. what is the best way to make the file less
heavy.
do you have any idea?
--
Miri Tz.

i forgot to mention that the heaviest sheet is like a data base which
includes a lot of data. a lot of vlookups are related to it.
--
Miri Tz.


"Miri" wrote:

hi, i would like to get your advice regarding a problem i have with a big file.
i have a big file that exist alot of sheets with vlookups and formulas
between them.
one of the sheet is the heaviest. what is the best way to make the file less
heavy.
do you have any idea?
--
Miri Tz.

On Mar 19, 4:21 am, Miri wrote:
i forgot to mention that the heaviest sheet is like a data base which
includes a lot of data. a lot of vlookups are related to it.
--
Miri Tz.



"Miri" wrote:
hi, i would like to get your advice regarding a problem i have with a big file.
i have a big file that exist alot of sheets with vlookups and formulas
between them.
one of the sheet is the heaviest. what is the best way to make the file less
heavy.
do you have any idea?
--
Miri Tz.- Hide quoted text -

- Show quoted text -

Try eliminating any formatting in it such as color filled cells and
make sure your formulas dont "run" all the way down to rows you will
not be using for a long time. Just be sure to autofill your formulas
every so often.

I've run into this problem myself before and the above really helped
me.

-LT