[ExcelVBA] Keep Duplicate Data in External Query

 

For years used excel 2003 for retrieving external data. In the Last month my queries skip all duplicate data entries. I want the duplicates in this instance. Is there a way to correct this?

I have tested the problem on three different computers with the same result.

If you would like to recreate my problem, starting at cell A4 enter the same ticker symbol thru cell A10. Place your curser in cell B1 and get the external data for the stocks listed starting with cell A4. I used AAPL for the test. Eight entries returned only one data result.

Jim

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 2

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___