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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
You must log in or register to reply here.

Similar threads

I
  • Question
Microsoft Excel - REQUIRE MACROS
2
Replies
15
Views
1K
infrequentcoder
I
A
  • 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
453
RBachman
R
D
  • Question
Dealing with VBA error 1004 when refreshing all data connections due to connection only queries
Replies
8
Views
6K
Fluff
Fluff
C
  • Question
Export Excel Data to Access Table or Query using Excel VBA
Replies
0
Views
3K
craigb1155
C

Forum statistics

Threads
1,214,921
Messages
6,122,280
Members
449,075
Latest member
staticfluids

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