Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I calculate Nash-Sutcliffe efficiency in EXCEL? | Excel Discussion (Misc queries) | |||
Equation Efficiency? | Excel Worksheet Functions | |||
Calculation Efficiency (Speed)? | Excel Discussion (Misc queries) | |||
Range efficiency | Excel Worksheet Functions | |||
.select efficiency | Excel Programming |