• Ideate BIMLink
  • Getting Started
    • What's New with Ideate BIMLink
    • User Interface Overview
    • Step 1: Getting Started with Ideate BIMLink
    • Starting Ideate BIMLink
  • Using Ideate BIMLink
    • Creating Links
      • New Link Category Dialog
      • New Link Details
      • Load Sample
      • Create a Link from a Schedule
        • Schedule Import Results
      • Instance vs. Type Links
      • Multi-Category Links
    • Managing Links
      • Saving Links
      • Loading Links
      • Duplicating Links
      • Convert Link
      • Renaming Links
      • Deleting Links
    • Link Properties
      • Link Preview
      • Link Tab
      • Categories Tab
      • Properties Tab
        • Available Properties
        • Display Filters and Grouping
        • Include Linked Elements
        • Read-Only Properties
        • Coordinate Properties
      • Filters Tab
        • Filtering Examples
      • Sorting Tab
    • Export to Excel
      • Exporting to an Existing File
    • Import From Excel
      • Import Dialog
      • Import Issues
        • Error Issues
        • Warning Issues
        • Message Issues
  • Working in Excel
    • Excel File Formats
    • Excel Naming Conventions
    • Property and Cell Units
    • Supported Excel Functions
    • Excel Tips
      • Formatting Tips
      • Using Formulas in Cells
      • Organizing Excel Data
      • Using Dropdown Lists
  • How to...
    • Create NEW Elements
      • Create New Sheets
      • Create New Rooms or Spaces
      • Create New Masses and Generic Models
      • Create New Areas
      • Create New Schedule Keys
      • Create New Revisions
    • Use Ideate BIMLink for Quality Control
      • Audit Names for BIM Protocol Standards
      • Manage Duplicate Type Marks
      • Audit Interior Elevation Names
      • Who Did That?
    • Managed Sheet-based Revisions
    • Manage Key Schedule Data
      • What is a Key Schedule
      • Edit Key Schedule Data
    • Manage Project Standards
      • Re-Use Modified Families
    • Utilize Type Swapping
      • Title block Assignments
      • Update a Door Schedule
      • Update the Structural Model
    • Manage Calculated Values within Tags
      • Occupancy Data
    • Leverage Linked File Data
      • Linked Files and Room Data
      • Import Linked File Data
    • Assign Space Types
    • Construction Tasks
      • Create a Quantity Takeoff
      • Receiving Field Coordinate Point Data
      • Sending Coordinate Data to the Field
    • Use Ideate Sticky with Ideate BIMLink
    • Video Examples
  • Troubleshooting
    • Frequently Asked Questions
    • Performance Tips
    • Worksharing Considerations
    • Linked Files and Spatial Data
    • Known Issues
    • Error and Warning Messages
      • Ideate BIMLink Messages
      • Revit Messages
      • Import Issues
    • Unsupported Revit Properties
• Ideate Explorer
  • Getting Started
    • Starting Ideate Explorer
    • What's New in Ideate Explorer
  • Explore Revit Warnings
    • What is a Revit Warning?
    • Review Warnings
    • Manage Revit Warnings
    • Set Warnings Standards
    • How to Resolve Revit Warnings with Ideate Explorer
      • Common Revit Warnings
      • Calculated Revit Warnings
      • Geometric Warnings
  • Ideate Explorer Basics
    • Introduction to Ideate Explorer
      • Display
      • Alerts
      • Sort By Options
        • Category View
        • Level View
        • Phase View
        • Room and Space View
        • Zone View
        • Workset View
        • Edited By View
      • Filter
      • Search
      • Explore
      • Navigate
      • Results
      • Using Auto-hide
    • Tools
      • Saved Selection Tools
      • Ideate Delete
      • Refresh
      • Detail View
      • Export to Excel
      • Zoom Tools
      • Right-click Menu
      • Show Elements
  • Ideate Query
    • Getting Started with Ideate Query
    • Available Properties
    • Ideate Query Examples
      • General Purpose Queries
      • Architectural Queries
      • Structural Queries
      • MEP Queries
    • Tips for Working with Ideate Query
    • Ideate Query Known Issues
  • BIM Managers
    • Project Auditing
      • Auditing Overview
      • Element Count
      • Model and Detail Lines
      • Keynotes and Revisions
      • Clean Up Text and Dimensions
      • Scope Boxes and Plan Regions
      • Grids, Levels, and Reference Planes
      • Auditing Groups
      • Finding In-Place Families
    • Family Auditing
  • How to...
    • How Do I Delete a Hidden DWG?
    • How Do I Purge Imports?
    • How Do I Export to Excel?
    • How Do I Use Explorer to Swap Types?
    • How Do I Manage Worksets?
    • How Can I Create a Custom Filter?
    • How Can I Use Ideate Query for Quality Assurance?
    • How Do I Delete ALL Identical Instances?
    • How Do I Search by a Parameter Revit Value with Ideate Explorer?
  • Troubleshooting
    • What does the "No Good View Can Be Found" Message Mean?
    • Export Limitations
    • Can I Leave Ideate Explorer Open and Continue to Work In Revit?
    • Why Can't I Select Anything?
    • What Does the Yellow Symbol Mean?
• Ideate Sticky
  • Getting Started
    • Starting Ideate Sticky
    • What's New in Ideate Sticky for Revit
    • Step 1: Getting Started with Ideate Sticky
  • Using Ideate Sticky
    • Preparing the Excel file
    • Font Size Mapping Chart
    • Mapping Excel Line Styles in Ideate Sticky for Revit
    • Using Special Characters
    • Creating a Sticky
    • Sticky File Properties
    • Sample Files
    • Editing the Sticky
      • Editing in Revit
      • Editing in Excel
      • Updating the Sticky
  • How to...
    • Manage the Size of Sticky
    • Use Ideate Sticky with Ideate BIMLink
    • Work with Pivot Tables
    • Publish Project Start Up Views
    • Import Revit Images into Excel Files with Ideate Sticky
  • Troubleshooting
    • Frequently Asked Questions
    • File Opening Messages
    • Known Issues
    • Errors and Warning Messages for Ideate Sticky for Revit
• IdeateApps
  • Getting Started Guides
    • What's New
    • Setting Shortcuts
  • Ideate ReNumber
    • Using Ideate ReNumber
      • Numbering Methods
      • Customizing Ideate ReNumber
        • Rule Management
        • Rule Value Definition
      • Sample Rules
    • How To...
      • Manage Door Numbering
      • Number Parking Along a Path
      • Avoid Unique Numbering Issues
      • Include the Linked File Room Number
    • FAQ
  • Ideate QuickSelect
    • Using Ideate QuickSelect
      • Results
      • Right-click Options
    • FAQ
  • Ideate SmartDelete
    • Using Ideate SmartDelete
    • How to...
      • How to Find Views with Deleted Elements
      • How to Know When it is Safe to Remove a Linked File in Revit.
    • FAQ
  • Ideate XRay
    • Using Ideate XRay
      • Select the Missing Element
      • Select the Target View
      • Review the Results
      • Resolve the Issue
    • Examples
      • Example: Phase
      • Example: Annotation Crop
      • Example: Level Extents
    • How To...
    • FAQ
    • Unresolved
  • Ideate SpellCheck
    • Using Ideate SpellCheck
      • Select Which Views to Check
      • Language
      • Fixing Spelling Errors
      • Understanding Warning Messages
      • SpellCheck Results
    • How To...
    • FAQ
  • Ideate Sheet and View Tools
    • Ideate SheetManager
      • Using Ideate SheetManager
        • Searching Views
        • Searching Sheets
        • Sheet Composition
        • Controlling Viewport Types
        • SheetManager Tools
      • FAQ
    • Ideate Align
      • Using Ideate Align
        • Set the Alignment View
        • Select the Views to Align
      • How To...
      • FAQ
    • Ideate Clone
      • Using Ideate Clone
        • Cloning a Sheet
        • Viewport Options
      • FAQ
    • Ideate ViewCreator
      • Using Ideate ViewCreator
        • ViewCreator Overview
        • Preview & Create
        • Resolving Warnings
        • Customizing Ideate ViewCreator
          • Rule Management
          • Creating Custom Rules
            • View Name Definition
            • Property Overrides
        • Sample Rules
      • How To...
        • Control Level Name
        • Copy to a Revit Design Option
        • Create Scaled Views
        • Create Sector Plans
      • FAQ
  • Known Issues
• Ideate StyleManager
  • Getting Started
    • Starting Ideate StyleManager
    • User Interface Overview
  • Using Ideate StyleManager
    • StyleManager Basics
    • Object Style Management
    • Line Style, Line Pattern and Fill Pattern Management
    • Material and Appearance Asset Management
    • Filter, View Template and Scope Box Management
  • How To...
    • Delete Imported Object Styles
    • Clean Up Your Title Block
  • Troubleshooting Ideate StyleManager
    • FAQ for Ideate StyleManager
    • Known Issues in Ideate StyleManager
    • Performance Tips
• Licensing
  • Manage Software License Dialog
    • License Types
    • License Modes
    • License Status
  • Standalone Licensing
    • Standalone License Activation
    • Standalone License Transferring
    • Standalone License Activation Troubleshooting
      • Offline Activation
      • Virtualized Environment Detected
      • Re-setting a Trial Period
      • 'No Internet Access' Error
      • License File Corrupted
  • Ideate Software Network Licensing Guide
    • Network Licensing FAQ
    • How Network Licensing Works
    • Setting Up the License Server
    • Setting Up the Workstations
    • License Borrowing
    • Setting Up the Deployment Installation
    • Adding to a Revit Deployment
    • Updating Existing Ideate Network Licenses
    • Troubleshooting
• Ideate Software License Agreement

Email Support

Supported Excel Functions for Revit Modeling with Ideate BIMLink

Not all Excel functions are supported upon a Revit import into Ideate BIMLink. While most mathematical function calls are supported you may find some, like those related to accounting, that may not work.

Suggestions for using unsupported functions:

• The .XLSX file format treats certain characters differently than the .XLS file format. Switching to the .XLS may allow the function to work as expected.
• Placing the function in a new column and then copying the cells, and use ‘paste special’ to paste the values in the column that will import into Revit.
• Still stuck?  Contact us, and we'll see if we can help: support@ideatesoftware.com