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.

By entering your data above and clicking ‘SUBMIT’ you are consenting to the collection and use of that data to respond to your comments and inquires, as described in our Privacy Policy. We may also transfer the data you submit in the ‘Email Us’ form to our VAR partners for the limited purpose of a sales follow-up. Please review our Privacy Policy for more details on how and when we collect data and what we use it for.