"Unable to Import the Excel File..." Messages displayed in AutoPIPE


Applies To
Product(s):AutoPIPE
Version(s):ALL;
Environment: N/A
Area: Import
Original Author:Bentley Technical Support Group
Date Logged
& Current Version
Nov. 2016
10.01.00.09

Problem:

The following is displayed when using AutoPIPE

---------------------------
Unable to Import the Excel File
---------------------------
Excel Imposed Support Displacement data could not be inserted into the model. For details View the error log.
---------------------------
OK
---------------------------

Why does it appear and What should i do now to avoid it?

Solution:

This message is displayed when a problem occurs during importing of a specially formatted Excel file using " Import Imposed Displacements" command

There are a number of reasons why the import may fail but one or more of the following listed items may resolve the issue. This is an iterative process. 

a. Be sure that MS Excel is installed on the computer. Suggest v.2007

b. Save Excel file back to "Excel 97-2003 Workbook (*.xls)" format

c. The imported Excel file cannot have any blank Translation or Rotational values. If the value is Zero enter a Zero number in the blank spot.  

Now try and import the Excel file, the message above should not appear. 

See Also

Warnings, Errors, Crashed, Confirm Messages in AutoPIPE

Bentley AutoPIPE