I have a workbook with 7 report worksheets, each generated by pressing its appropriate button on a data worksheet. There are 12 supporting data worksheets, for a total of 19 worksheets. 6 of the report worksheets contain images and textboxes that bring in cell values from other data worksheets. One report is simply 2 worksheets of cells. This one report when run in 2003 runs in 2 seconds. In 2007 it takes 1 min 45 secs. It appears that it is the textboxes on the other 6 reports that are slowing down the report generation process...determined this by removing the image/textbox worksheets and confirming by simply removing the textboxes from the worksheets. With those 2 trials the report ran in 7 seconds. I was hoping that by changing to manual re-calculation using VBA, it would exclude the textboxes on the other worksheets, but that did not work. I'm thinking that somehow the textboxes need to be prevented from being re-evaluated and from being refreshed on the 6 reports that are not being regenerated when this one is. Does anyone know if my evaluation is flawed or if there is a way to prevent textboxes on other worksheets from being refreshed?
This is my first VBA project and have not had any success finding anything on MS's site about textboxes and how they are handled differently in 2007 vs. 2003.
This is my first VBA project and have not had any success finding anything on MS's site about textboxes and how they are handled differently in 2007 vs. 2003.