Value Function not updating
 

I have a SQL query that returns a string that represents a number. It appears
as a number but a pivot table boes not treat it as a number. So I use the
value function to converit to a number however colunm of values does not
updat when the reports runs automatically.

How can I get the value function to update in the background?
Can I usse vb to convert the whole colunm that is text to a number?

Thanks