Search results

Looks like this approach is a winner; it still seems irredeemably kludgy to me in principle, but in practice it is much more elegant and effective than the alternatives... of which there are none. So. I've only implemented this in a little test workbook so far but it worked perfectly. Main...

It does help, though, I would be remiss if I didn't thank you for replying. I've seen that link before but you did find the one page the internet that holds the best hope for me right now as far as I can tell :).

Narayank991, yeah, I ran across that in my Googling; I had hoped there may be some other way, as that route (briefly switching the connection to OLEDB from ODBC) has some drawbacks for me. It looks like there's no alternative, though, so I'm implementing and testing that now. I'll update here if...

(Update: I did some checking and realized I was wrong on one point. My first method (using non-shared PivotCaches) did also result in the creation of many new Connections, I just hadn't looked closely enough. So the bonus point question is now: How to modify CommandText without creating a new...

I'm trying to write VBA to change the CommandText property of each query in a Workbook, but I'm having some trouble. I'm using Excel 2010. At first, I had 5 Worksheets and each one had a single PivotTable with its own PivotCache. 5 Worksheets, 5 ODBC connections, 5 PivotCaches, 5 PivotTables...

Thanks for the link, guys!

Hello, I'm trying to find the best way to create KPI dashboards (using Excel 2010 on Windows 7) that can be used by both Windows users and Mac users (Excel 2011 for Mac). From what I can tell, there are a few options, none of them perfect. So far, though, it has been extremely frustrating...