Help - Web data source stopped working with formulas

[Daniel86]

Hi everyone,

So, this is very strange. I have no idea what could have caused this!
I've made my own little portfolio worksheet which keeps up with the value, yield and profits for some Danish equity options.
The values are then being logged and shown in a graph.

So far, this has worked fine. I've refresh all connections and then the values would update themselves - piece of cake!

However, all of the sudden one day when I refreshed the web data, the formulas just started to show #VALUE! instead!?
The values from the web data showing the stock prices are all good and works perfectly, so why the f*ck will my formulas all of a sudden not work??

I've uploaded the workbook. Some help would be very appreciated!

Options book.xlsm

[AlphaFrog]

The downloaded data in the yellow area, the decimal points are now commas and Excel doesn't recognize them as numeric values.

This should fix it. Right-click on the Sheet1 tab and select View Code from the pop-up context menu. Paste the code below in the worksheet's code module.

Please Login or Register  to view this content.

[Daniel86]

Of course..!
Why didn't I think of that. I changed the language settings the other day

Sorry. But thanks!