Cannot access any connection properties when using XML Excel 2010

thomassharp

Board Regular
Joined
Dec 10, 2014
Messages
84
Hi when running XML with RSS feeds I need to set the data connection to refresh when the work book is opened - however all the options in the connection properties are greyed out. Things I have tried: ensuring I'd enabled data connections in trust center, saving file to trusted location, all other options in trust center, googling every related search term... Is this a necessary evil of running XML in Excel or what is going on here...The whole purpose of it is practically defeated if you can't change these options... Does someone know what will allow me to access these settings?
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Forum statistics

Threads
1,222,319
Messages
6,165,307
Members
451,951
Latest member
brentcole

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top