This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
My Excel 2013 program automatically updated itself on January 9, 2018. Since then, I'm unable to refresh my cells for gold and silver prices from jmbullion.com. I've been using this same file for over a year with no problems. Now when I attempt to update the data with "refresh all", a pop-up window asks me to "Enter your credentials." Why is it doing this? How do I fix this?
System: Windows 7 Professional, Service Pack 1, 64 bit, 16 gb memory
Subscription Product: Microsoft Office 365 ProPlus
Office Updates Version: 15.0.4997.1000
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
In that case we can't help you, sorry.
I suggest that you post the issue here:
https://social.technet.microsoft.com/Forums/off...
Andreas.
When trying to create a new query in a new excel spreadsheet, I get the same enter your credentials window. The problem began after the January 9 automatic update. I'm pretty sure it's a microsoft problem.
This problem of having to enter credentials when doing a Data-Refresh All in Excel 2013 from JMBullion.com was caused by YOUR automatic update of Jan 9.
Please fix and update.
Bill Reddy
Also I talked with two of your help folks and neither one knew what I was talking about. I can't believe I'm the first one to report this problem. You folks need to communicate with each other better.
The error message says it all, open the website in your browser and log in. Then try the query again.
If it fails, the issue is not addressed to Excel, the website has changed the data download process. Make a new file and try to create a new query for that page, I guess you'll see the issue.
Andreas.
I would suggest that you should post simultaneously to Technet forum also as there this will increase chances of getting the fast answer to this query. So, your question will be on two forums - This and Technet. On Technet, even Microsoft Product team will look into your issue.