• 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. J

    Base Excel Table on another Excel Table

    Can you use an Excel Table as a data source for another Excel Table? I have an Excel Table that uses SQL as a data source. The user needs to then manually edit the data in that table knowing they are not affecting the database and that it will be overwritten the next time the data is pulled. I...
  2. J

    Pivot Table as data source for an Excel Table in the same spreadsheet?

    @Luke M: Can you base an Excel Table on another Excel table and still have it dynamically expand to show only the number of rows needed to hold the data? That could possibly also solve my problem if I can do some aggregates during the pull and skip the Pivot entirely. I would pull it straight...
  3. J

    Pivot Table as data source for an Excel Table in the same spreadsheet?

    Is there a way to use a Pivot Table as the data source for an Excel Table? I need to use the data generated from a Pivot Table, but not in the order in which the Pivot Table can generate it and also with calculations that are easy in a table (subtract column A-B) but not in the Pivot (A is a Row...
Back
Top