User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

JMP Knowledge Base

Choose Language Hide Translation Bar
#REF values appear in JMP® data tables when importing from Excel®
Created: Nov 30, 2022 02:30 PM  |  Last Modified: Dec 23, 2022 1:40 AM

When importing .xlsx, or .xls workbooks into JMP®, #REF values may appear within a variable.

This is a known issue that stems from Excel formulas that are nested or conditional. The utility used to import the workbook does not process these formulas, which leads to missing cell references (#REF). 

Workarounds: 

  1. Save the .xlsx or .xls workbook as a text (.txt) file and import the data into JMP.
  2. Use the JMP Excel add-in to import the data

 

[Previously JMP Note 64666]

0 Kudos
Details
Operating System
Windows
Reported Version
14.0
Fixed Version
16.0
Products JMP JMP Pro

Recommended Articles