Is it possible to Calculate a single worksheet at a time?

H

Henry

Is it possible for Excel 2007 to calculate a single worksheet at a time?
The reason I ask is that I have a complicated 35mb worksheet, it take about
15 mins to calculate and I have a Dell Core 2 Quad core with 4 MB RAM.

When I make the change in the details in one worksheet, I would like to see
the change in that worksheet only to know if the formula models the scenario
properly.

This worksheet also feeds other worksheets but I do not want those updated
until I know the details are accurately done. Is there such a thing as
manually calculating a sinegle worksheet as oppose to the entire workbook?
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update date & time in a cell only when worksheet is changed 6
Linking Formulae Across a Workbook 2
Cannot copy worksheet to another file 2
how do I Calculate elapsed time worksheet is open 1
combine data from several worksheets into single worksheet 2
linking to a hidden worksheet 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Averages from different worksheets 4

Top