By default the spreadsheet is assuming that you have PC-SPAN installed. If you don't, you need to change your default path so it knows where to download and where to find the files.
If that is not the issue, try typing in CCH4 CCH4 C 3500 -1 in row 4 again, click Single position, select any cell in row 4 and click ok. If there is nothing returned in the gray area on the Main tab, let me know if you see any data at all in the first 5 rows of the Temp tab.
I have PC-SPAN installed and I see downloaded and uzipped Risk Array files in C:\Span4\Data Folder.
I typed in CCH4 CCH4 C 3500 -1 in row 4 again. There were nothing returned in the gray area and the first 5 rows in the Temp tab are blank.
There's nothing wrong with macros running if you can confirm that the spreadsheet is downloading the risk arrays properly. The fact that rows 1-5 are blank on the Temp tab makes me think that it isn't finding the correct lines because of an error.
I'll private message you a copy of the spreadsheet I use for troubleshooting ... maybe we can figure out why it is giving you grief.
It just dawned on me that I don't think you won't be able to get the attachment if I do it through a private message, so here it is.
Please bear with me on this one and don't take it personally if the instructions seem too basic ... I'm just trying to locate the error.
I attached a 97/2003 version so it didn't have to be zipped and I hid the code that forces and exit when there is an error.
Please go through these steps:
-Open the spreadsheet and click Enable Macros if a security warning appears.
-On the Setup tab, click Set Default Path and navigate to the folder where you want the data and then click OK.
-On the Main tab click Download Risk Arrays to download the files for Dec10.
-When that is done, click Portfolio.
Please let me know the results. If an error is generated please let me know what is highlighted in the VBA. If any of this doesn't make sense just let me know.
I went through all the steps but unfortunately everything remained as it was. Nothing is highlighted in the VBA. There were the following files downloaded to my C:\Span4\Data folder - cme.20131210.s.pa2 and nyb.20131210.s.pa2.
It seems like something is interrupting the code execution on your machine. The spreadsheet I sent you had code in it that should have renamed the cme.20131210.s.pa2 to cme.s.pa2, rename the nyb.20131210.s.pa2 to nyb.s.pa2, and then delete the zip files.
I'm not sure I know where to go from here. How familiar are you with editing VBA?