how to SPEED VARIABLES EVALUATION

[pellegrinosrl]

HI ALL!

I have a very big variables table with much IF to drive 

a lot of numbers, and every time i make a variation on  a line

it takes a lot of time to re evaluate every thing,

do some one knows if and how can i 

speed all this??

thank y so much

[JasonTitcomb]

Try turning off automatic update on the tools tab.

[12GAGE]

Get a faster computer.

[pellegrinosrl]

I don't know if really this is the problem..

i have an i7-6700 cpu 3.40GHz with 32 GB of RAM

and a a GEFORCE GTX 750 ti WITH 2GB of memory.

my SE file is only 3,2 MB, but has something like 200 variables

and every time ai change a line

or a simple cell or add a new one

it takes 20-25 sec for refreshing every thing.

I would like to know if there is some settings where 

to decide if and when let SE do the refreshing

thank you again

[JasonTitcomb]

So the Automatic Update setting seems to help when working with Excel files linked to the variable table.

It also helps when editing dimensions directly.

It does not help when working in the Variable Table itself.

Maybe  you should call that in to your reseller to file an IR so we can make the software better.

[12GAGE]

In general, I only have the variable open when they need to be edited. Having the variable tabel open at all really slows things down. Close the variable window and updates are much faster.

[pellegrinosrl]

Thank you for your responses!

I found that if opened through an assembly

my 200 user variables are much faster to edit.

I could write all the rules (trigonometrics and IF statements) of my sheet file

In an excel, but i pointed to give the main part of  intelligence to

SE (and also because really it's much simple)

I worked calculating all necessary in user variables part

and finally  giving the elaboration to quotes and suppressions.

Im now trying to transfer a part of this work to  a .bas file with VB.

Will let you know

Thanks again