View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Al Jager Al Jager is offline
external usenet poster
 
Posts: 5
Default Excel formulas efficiency

Can someone please help me with this problem?
In a range from cell D10 to D64 I have a series of
formulas.
The formulas are fairly complex and seem to take up a lot
of space.
All the formulas in this range relate to 1 Entry. For each
additional entry I copy the formulas. The workbook can
have as many as 10 entries. For each entry
the workbook increases in size by about 800 KB.
As a result the workbooks become rather large and slow in
operation.
Is there a way to share the original formulas, rather
then storing identical formulas more than once?.
Entries are entered in adjoining columns in the same ranges
i.e. E10 to E64 etc.
I have run Excel Repair to ensure, my Excel is functiong
O.K.

Many Thanks
Al