Excel - querying SQL

[SQLScholar]

Hey all,

I want to - for each row on a spreadsheet - query an SQL server and store the result into a field.

Now i am quite happy in creating the custom function to do the work. What i am concerned about, is how often its re-calculated?

Basically once its looked up, there is no need for it to change. I dont want the end user to save as values.

Basically - how often does this recalculate? On open of file? On change of related cell data?

Many thanks.

Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[PHV]

IMO, On change of related cell data, unless you made the function Volatile .

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SQLScholar]

Sorry to be stupid on this - how would i avoid making it volatile?

Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[xlbo]

Don't put "Application.volatile" anywhere in thecode !!

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SQLScholar]

Still it seems to calculate if i use a filter.

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------