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

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

Excel formulas efficiency
 

"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.

Al,
you could try and define your formulas as VBA functions in a separate module
within the workbook.

Example :

Public Function fcustMyFunction(ByVal param1 As Integer) As Double
fcustMyFunction = Sin(param1)
End Function

With this set up, you can go back to your worksheet. Use Insert Function,
"Function Category" = User Defined
You will get a list of the different functions you defined in your code, and
use them in as many cells / on as many entries as you wish without blowing
up your file size.

cheers,
Markus

Excel formulas efficiency
 

If the single entrys are adjacent in a single row, you could array enter
your formulas.

--
Regards,
Tom Ogilvy


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