Not saying it's a good thing or bad to put everything on a single sheet. But
you really have to think things out in advance with regards to the layout of
the various areas of information on it: how is adding a row or column to any
given area going to affect other data areas that 'share' use of the row or
column?

If speed of summary checking is the critical factor and you think this is
going to speed things up (I'm not convinced it will) then give it a try.

But again, give thought to the results of any changes on that single, large,
multi-function sheet - what are the ripple effects if you forget to "do it
right"? It might keep your life simple to have the data spread across
multiple sheets by 'function' - at least if you have to change the range that
the table/data requires, it won't have as much chance of creating an
unexpected (and possibly undetected) downstream effect.

"driller" wrote:

Hello,

If i have range of data, process formulation, summary check and print_ranges
spread around my 4 sheets....in one stand alone workbook.
Will it be advisable to place all of the above in one sheet, considering
that 2007version has a larger sheet platform....significantly making it a
stand alone spreadsheet.

At this moment, with excel2003, I am thinking to re-compose my 4 sheets into
one sheet, considering that my data has a range that may increase upon
re-extending the process formulation and summary check to include other extra
variables like estimation cost (which are done on separate workbook).

If this method is advisable, my summary checking will be easy, with due
concern to faster calculation and tracking of acceptable results.

I have not yet used the 2007v (not yet available here).

thanks for reading and advice.

regards,
driller
--
*****
birds of the same feather flock together..birdwise, it''s more worth
knowing the edges rather than focusing in one line! Know the limits and
remember the extents - dive with Jonathan Seagull