View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default Excel formulas efficiency

Seems like a lot of space for a single entry. How big is your formula?


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Al Jager" wrote in message
...
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