V
valglad
Hi,
I've got a relatively large spreadsheet (25 MB) with a lot of formulas
(some of them are UDFs). Most of the calculation is done in a sheet
called "data", the summary is presented in sheet "Report", which only
has about a couple of dozens of Sumifs but that's about it.
The purpose of that file is to allow the user to key in an order number
value in cell B5 after which all the recalcs kick in. It usually takes
about 15 secs to recalc, sometimes might take longer or shorter.
Now one of the users asked me to print summaries for all order numbers,
which is about a thousand. I can't imagine doing it manually, so I've
got to write a macro to do it. I can see looping through the order
numbers and printing the summary page for each one.
However, I don't know how to ensure that the summary page is printed
only after all recalculations are finished, otherwise it might print a
bunch of summaries with partially calculated formulas and then I'll get
crusified.
Could anyone give me some clue as to how to achieve this.
Thanks in advance.
I work with Excel XP
I've got a relatively large spreadsheet (25 MB) with a lot of formulas
(some of them are UDFs). Most of the calculation is done in a sheet
called "data", the summary is presented in sheet "Report", which only
has about a couple of dozens of Sumifs but that's about it.
The purpose of that file is to allow the user to key in an order number
value in cell B5 after which all the recalcs kick in. It usually takes
about 15 secs to recalc, sometimes might take longer or shorter.
Now one of the users asked me to print summaries for all order numbers,
which is about a thousand. I can't imagine doing it manually, so I've
got to write a macro to do it. I can see looping through the order
numbers and printing the summary page for each one.
However, I don't know how to ensure that the summary page is printed
only after all recalculations are finished, otherwise it might print a
bunch of summaries with partially calculated formulas and then I'll get
crusified.
Could anyone give me some clue as to how to achieve this.
Thanks in advance.
I work with Excel XP