Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why has the sum function stopped auto-updating? | Excel Discussion (Misc queries) | |||
Custom Function not updating | Excel Worksheet Functions | |||
Custom Function not updating | Excel Worksheet Functions | |||
how can I use the NOW() function without it updating thetime? | Excel Worksheet Functions | |||
How can I use the NOW function and keep it from auto updating? | Excel Worksheet Functions |