Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

As a part of providing dynamic dashboards / reports, I've been investigating having a static Excel workbook that would contain a raw data sheet periodically updated from a web source. I'm currently using Excel 2010.

I really want to keep the workbook VBA / macro-free to reduce friction and potential errors.

My initial attempt was to add it as a workbook connection under Data -> From Other Sources -> From XML Data Import and pointed it to the url of the remote Excel workbook. This does pretty much what I want... except for sheets with more than 255 columns, unfortunately. They're simply truncated.

Is there really no way to just get Excel to include / refresh another sheet pulled from the web? If not, what would be the general approach otherwise? It seems like a pretty common usecase :-)

share|improve this question
    
Do you control the web source? – Andi Mohr Jan 17 '13 at 12:31
    
Yes. I have full control of the web source. – RasmusKL Jan 19 '13 at 7:59
up vote 1 down vote accepted

The solution I found to exceed the 255 column limit was to simply create a raw XML document (not an Excel workbook) and have Excel consume that. It's a bit more bandwidth more heavy (haven't experimented with compression), but at least it works.

share|improve this answer
    
Thanks for posting your solution! – Andi Mohr Jan 21 '13 at 9:41

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .