Work with Pivot Tables

An Excel Pivot Table is an interactive way to quickly summarize large amounts of data. You can find the Pivot Table command on the Insert tab within the Table pane. Ideate Sticky can import data from a Pivot Table but not all of the formatting will come across due to the nature of the Pivot Table. Within a Pivot Table, Excel is creating many formatting overrides to the cells. Below are some tips for managing some of the formatting conditions that are unique to Pivot Tables.

Tips for working with pivot tables in Excel

Refer to the sample file ISB-Revit_Starting_View.xlsx for an example of the use of a Pivot table.  In this file the 2nd worksheet has some data about the Revit Linked files which is in turn referenced by a Pivot table shown on the primary worksheet.

Related Ideate BIMLink Topic: Create a Quantity Take-off

Submit feature or issue request for Ideate Software

Thank you for taking time to inform us about a bug or feature request.

If you'd like to upload a file to help explain the issue, you can upload a file to Hightail.