• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. K

    Changing SQL query (CommandText) of shared PivotCaches

    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...
  2. K

    Best practices for Mac-compatible dashboards?

    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...
Back
Top