"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

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