calculation

[Miki]

Hi
I have a workbook of about 20Mb and a lot of problems with calculating it.
Unfortunately, there are lots of various formules, i don't really have any
idea how to cut it....
Do you have any idea how to calculate such a big file without the break down
of the computer?
'couse every time i try to do so, an hour or more it takes and in 90% i have
to stop the process.......
Is there an option possible that only one specific cell is calculate?
thank you for any help,
Regards
Ann.

 

[Guest]

It sounds like you may have some issues in the way the spreadsheet is structured, whcih I think you need to sort out.

However, to answer your question, you can limit calculation to a single sheet like this:

Set calculation to manual (I suspect you have already done this), then when you want to calculate a specific page, press Shift+F9

 

[Miki]

Hi,
unfortunately I've already done that... I calculate it usning shift+F9, and
even if the programm is still breaking down. I've already sort out all that
is possible to sort....
it is just the structure of used formules - which contain searching
54272cells.
There are mostly sum.if
Ann.

It sounds like you may have some issues in the way the spreadsheet is

structured, whcih I think you need to sort out.

However, to answer your question, you can limit calculation to a single sheet like this:

Set calculation to manual (I suspect you have already done this), then

when you want to calculate a specific page, press Shift+F9