I have a report that calculates GL Expenditure. On the first worksheet is where you enter the chosen date range. I also have 12 other worksheets that automatically calculate the information for each calendar month. This report (due to all the calculations) takes about 8 minutes to run.
Is there a way to disable the 12 worksheets from running in Jet? If so, I could do some sort of IF statement whereby a user could enter YES or NO in a field in answer to if they wanted to run the monthly calculations. A 'YES' would enable the 12 worksheets to run and a 'NO' would stop them running, thus saving a lot of time.
Is this possible?
Many thanks, Paul
Prevent a worksheet from running in Jet