Quickly review Error Report by parsing Element ID in spreadsheet

I find the Error Report – Warning – Select by ID process to be a little unwieldy in Revit (at the moment).

Here is a little process that may speed things up for you when reviewing a Error Report in Revit.

  1. Save Error Report to HTML
  2. Open HTML Error Report
  3. Copy data to Excel spreadsheet.
  4. Use RIGHT formula to extract only the id number to a new column.
    eg =RIGHT(C3,7)
  5. Copy the cell containing the id number to the ‘Select Elements by ID’ dialog in Revit.

Leave a Reply

1 Comment threads
0 Thread replies
Most reacted comment
Hottest comment thread
0 Comment authors
Luke Johnson Recent comment authors
newest oldest most voted
Notify of
Luke Johnson

You can also use Excel to 'sort' the View column – then you will be able to work on all the affected elements View-by-View.