Is it possible to pause the connection whilst in Design mode so that it doesn't keep connecting with the DB and calculating?
Find it time consuming/annoying to have to pause whilst the file calculates.
Thanks,
Rich
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello Rich,
You can disable Excel's auto calculation by going to File > Options > Formulas > Workbook Calculation.
You can also go to the Jet Ribbon > Application Settings > Performance > disable "Enable Excel automatic calculation when restoring formulas".
There is no way to disable Jet's calculation as it is going to the database to give you a sample of the information to ensure that your queries are constructed properly.
Regards,
MWilson
Please sign in to leave a comment.