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

--
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)



"Miri" wrote in message
...

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

--
Miri Tz.

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


"Bob Phillips" wrote:

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)



"Miri" wrote in message
...

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

--
Miri Tz.

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)



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


"Bob Phillips" wrote:

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)



"Miri" wrote in message
...

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

--
Miri Tz.