Hi SB
Open the excel file with macros enabled.
Click the "Update" button (macro takes about 15secs to run on my internet speed)
....then the "empty" s/sheet becomes a "not empty" s/sheet !!! updated with the last trading days data.
..... or are you perhaps suggesting that the upload corrupted the macro and nothing is working?
Let us know how you go.
M