Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a file containing approx. 200 rows, each row starts with a Stock ID
and I use MSNStockQuotes to return the last price stock value. It works successfully for the first 100 or so rows, then randomly doesn't work for the second 100 rows. Maybe 30 or 40 of the last 100 rows doesn't work. If I change the stock id on each row that doesn't work and then hit backspace it works successfully. It seems very random on the 30 or 40 that don't work in the last 100 rows, and nearly everytime the first 100 rows work flawlessy. Anyone else seen this and have a fix for it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF function to blank without getting #value in sum function | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |