This is a very ambiguous question as I am unsure if what I am asking is
at all possible, and struggle to even begin on how to search for it...

I have a very large WB that has multiple sheets with various
calculations and individuals updating it on a daily basis.

All this informatio is then consolidated into one worksheet which
presents a variety of information using calculations, conditional
formatting, and graphs. When the daily update is complete the audience
is notified that the daily figures are ready to view.

This consolidation sheet is the only sheet viewed by the audience so I
want to drop the size of the WB by making this sheet the only available
piece of the workbook.

Is it possible to split parts of a WB after the daily update into a
smaller file for general viewing which includes all formatting, graphs,
etc

Any help greatly appreciated

Kristan


--
Kstalker
------------------------------------------------------------------------
Kstalker's Profile: http://www.excelforum.com/member.php...o&userid=24699
View this thread: http://www.excelforum.com/showthread...hreadid=402055