Yesterday i made more then 200 variables for calculating information.
Now i am busy to make formula’s in the data sheets. Every time i put a formula in one cell and pressing enter i have to wait for more then 50 seconds before everytime is loaded again. You can imagine my frustration about this. Is it possible to stop the calculation and refreshing after one formula is set? So i can put everything in because i have to put now 150 formulas x 55 seconds…
Version 6 was ages ago- so my memory may not serve me well. Didn’t it also include a “Structure mode”? If so - adding formulas in that mode wont cause a view mode refresh.
I guess you have a large amount of data in your report as well. If possible, reduce the data set by adding query filters that output lets say 20 rows or less. The refresh should be comparatively faster.
(BOB member since 2002-08-15)