Hi Chersie,
Without a much more intimate knowledge
of your workbook, it is difficult to be
categoric about the size of your workbook;
at its most benign, the size could simply be
a legitimate reflection of sheer volume of
data,
That said there are various general areas
which may be addressed:
(1) Reduce the size of each of the 32
worksheets to the real data area. In this
connection, see Debra Dalgleish's
suggestions on restiing the Used Range
at:
http://www.contextures.com/xlfaqApp.html#Unused
(2) Consider if 32 sheets really are necessary.
If, as potentially suggested by another
thread, the first sheet represents a master
database and the remaining sheets display
subordinate detail, perhaps you might
consider:
- deleting the detail sheets and using
the Excel's AutoFilter, Advanced
Filter or Pivot Table tools to provide
the reuired report information.
If you are not familiar with these tools,
see Debra Dalglesh at:
Excel -- Filters -- AutoFilter Basics
http://www.contextures.com/xlautofilter01.html
Excel -- Filters -- Advanced Filters -- Introduction
http://www.contextures.com/xladvfilter01.html
Using Pivot Tables in Excel
http://www.peltiertech.com/Excel/Pivots/pivottables.htm
(3) If the 14 macro buttoms on each of
the 32 sheets perfom analagous operations,
consider replacing the 32 x 14 buttons with
a customised toolbar with a single set of
buttons, possibly adapting the button code
to operate on any of the sheets of interest.
However, the relevance of the above
suggestions will depend on your data and
your particular requirements; the suggestions
are, therefore, to be regarded as points for
consideration.
