good morning,
i have recently built an excel workbook containing 14 sheets, all sheets read data from one main sheet. three of the 14 sheets are big tables streaching out from row 2 till row 250 and going across from column A till column CJ
all formulas colculate from row 2 till row 1,000 in anticipation that the amount of information would grow.
i have already reduced the number of rows from 5,000 till 1,000
my problem is that the workbook is tarting to become unberably slow to work on, any adjustments done we must wait a good 10 minuets for the sheet to finish calculating, even when adding simple things such as a new title that has no inputs in any formula!!
can any one sugest ways to make the sheet faster, or to stop the sheet from calculating every time i do anything on the sheet
thanks
i have recently built an excel workbook containing 14 sheets, all sheets read data from one main sheet. three of the 14 sheets are big tables streaching out from row 2 till row 250 and going across from column A till column CJ
all formulas colculate from row 2 till row 1,000 in anticipation that the amount of information would grow.
i have already reduced the number of rows from 5,000 till 1,000
my problem is that the workbook is tarting to become unberably slow to work on, any adjustments done we must wait a good 10 minuets for the sheet to finish calculating, even when adding simple things such as a new title that has no inputs in any formula!!
can any one sugest ways to make the sheet faster, or to stop the sheet from calculating every time i do anything on the sheet
thanks