Cannot access any connection properties when using XML Excel 2010

T

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

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
You must log in or register to reply here.

Similar threads

I
  • Question Question
Microsoft Excel - REQUIRE MACROS
2
Replies
15
Views
2K
infrequentcoder
I
O
  • Question Question
Cannot trap error when using Excel's built-in stock price functionality in a macro. It used to work well!
Replies
1
Views
217
OaklandJim
O
A
  • Question Question
Excel custom ribbon disappears when running macro
Replies
0
Views
1K
avcape
A
R
  • Solved
Excel VBA no automatic break when divide by 0
Replies
4
Views
578
RBachman
R
D
  • Question Question
Dealing with VBA error 1004 when refreshing all data connections due to connection only queries
Replies
8
Views
8K
Fluff
Fluff

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

Share this page

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