ashgull80
09-03-2007, 11:54 AM
hi
i have a workbook with about 10 pages and the workbook was running perfectly but i then created a page which has lots of formulas.
it now makes the general running of the workbook very slow, it takes about 1min to open a userform
i was thinking that i could put these formulas in a seperate workbook so that the original workbook runs quicker! is this a good idea or does someone else have a better one??
the formulas works out total takings for different dates
eg
column 'a' has date (can be any time in the last 15yrs)
column 'b' has a value of money taken on that date
then on a seperate page a formula works out total takings for each month, year ect..
thanks ash
i have a workbook with about 10 pages and the workbook was running perfectly but i then created a page which has lots of formulas.
it now makes the general running of the workbook very slow, it takes about 1min to open a userform
i was thinking that i could put these formulas in a seperate workbook so that the original workbook runs quicker! is this a good idea or does someone else have a better one??
the formulas works out total takings for different dates
eg
column 'a' has date (can be any time in the last 15yrs)
column 'b' has a value of money taken on that date
then on a seperate page a formula works out total takings for each month, year ect..
thanks ash