Problem with refreshing pivot using external data

Hi,

I currently have a pivot data linked to an external excel source, which gives me the following pivot table:
1.JPG

When i try to refresh the file, and thus running the query again, it gives me a completely different value:
2.JPG

As you can see in the pictures above, the connection ignores the comma. Any idea how to solve this?

Thanks!

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Margaret1. Please don't hijack threads, or revive old ones. It violates Rule 4, as it can lead to huge confusion. Take a moment to read the yellow banner at the top of this screen and start your OWN thread, clearly described, with a sample Excel sheet to illustrate it (and manually calculated expected results, if appropriate).