Work with Excel Pivot Tables in Ideate Sticky for Revit

An Excel Pivot Table is an interactive way to quickly summarize large amounts of Revit 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 and Manage BIM Quantity Take-off Data for Revit with Ideate BIMLink

Submit feature or issue request for Ideate Software

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