heavy file...

[Guest]

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?
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.

 

[Bob Phillips]

What does heavy mean, and what is the objective of making it less so, what
is the problem?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

heavy means large file. with alot of formulas, every calculation takes time.
--
Miri Tz.

What does heavy mean, and what is the objective of making it less so, what
is the problem?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Bob Phillips]

There will probably be many things that you can do, but it depends upon the
data. Start here http://www.decisionmodels.com/calcsecrets.htm

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

heavy means large file. with alot of formulas, every calculation takes
time.