Registering Excel-Link as an Add-in
This manual is in pilot operation.
|
[Excel-Link] is provided as a Microsoft Excel Add-in file. Embedding the Add-in file into Excel so that its functions become available when Excel is started is called Add-in registration. In most cases, [Excel-Link] can be embedded into Excel through an automated procedure. As an exception, when multiple versions of Excel are installed on the same PC, the automated procedure may register the Add-in only in one of those Excel versions. In such cases, manual Add-in registration is also possible.
Automatically Registering Excel-Link as an Add-in
Start one of the following programs: [Manager], [Browser] or [Contributor], then select the following menu:
Please close Excel before executing this operation. If executed while Excel is running, the embedding process may fail. In that case, an error message will be displayed.
Installing Excel-Link Using the Excel-Link Installation Batch Program (fusion_place >= 14.0)
You can install [Excel-Link] using a batch program. By using this program, [Excel-Link] can be installed without launching the client program. When installing [Excel-Link] on multiple PCs, distributing this batch file to each user allows efficient installation.
Step 1. Obtain the Excel-Link Installation Batch Program
-
Open a web browser and log in to the Menu Page of fusion_place.
-
Click the download button of [Excel-Link] in the Resource menu.
Manually Registering Excel-Link as an Add-in (fusion_place < 14.0)
Step 1. Obtain the Excel-Link Add-in Files
To manually register [Excel-Link] as an Add-in, the Excel-Link Add-in files (Microsoft Excel Add-in files) are required. After installing fusion_place, the Excel-Link Add-in files can be obtained through the following procedure:
-
Access the fusion_place Menu Page with a web browser. The URL of the Menu Page is as follows:
http://(host):(port)/fusionplace/
(host) is the host name of the server to connect to, and (port) is the port number.
Host name:
If fusion_place is used in standalone mode, the host name is localhost.
If used with a Web Server, specify the Fixed IP Address or Host Name of the server.
Port number:
The port number specified during fusion_place installation.
If you used the default value proposed by the installer, this will be 50000.
(Example 1) If used in standalone mode with port number 50000, the URL is:
http://localhost:50000/fusionplace/
(Example 2) If used with a Web Server whose IP address is 192.168.0.2 and port number is 50000, the URL is:
http://192.168.0.2:50000/fusionplace/
(Example 3) If used with a Web Server whose host name is fusionplace.mycompany.com and port number is 50000, the URL is:
http://fusionplace.mycompany.com:50000/fusionplace/ -
Click "Download Excel-Link Add-in Files" on the displayed menu.
A “File Download” dialog will appear requesting whether to open or save the file. -
Select Save.
The “Save As” dialog will appear requesting the save location and file name. -
Select the save location and click Save. The file name initially appears as fp-excel-link.zip; this default name is fine.
The download process will begin. -
The downloaded file is in zip format, so extract it (right-click the file and select Extract All…).
Two Add-in files will appear:- fp-excel-link.xla
-
Main Add-in file for [Excel-Link]
- fp-excel-link-ribbon.xlsm
-
Ribbon Add-in file for [Excel-Link]
-
Save both files (fp-excel-link.xla and fp-excel-link-ribbon.xlsm) in an easy-to-find location (they will be used in the next step).
Step 2. Register Excel-Link as an Add-in
To use [Excel-Link], register the Excel-Link main Add-in file (fp-excel-link.xla) and the Ribbon file (fp-excel-link-ribbon.xlsm) as Add-ins.
Since [Excel-Link] main and Ribbon files are Microsoft Excel Add-ins, they can be registered using the standard Add-in registration procedure. When registering the Ribbon Add-in, be sure to register the Excel-Link main Add-in first.
⚠ [Excel-Link] can be used even without Add-in registration. However, in that case, you must open the Add-in file each time you use it, which is inconvenient. This manual assumes that [Excel-Link] is registered as an Add-in.
Once [Excel-Link] is registered as an Add-in, a tab named “fusions” appears in the Excel menu (Ribbon) when Excel starts.
The Add-in registration procedure is described below. The steps below explain how to register the [Excel-Link] main Add-in; registering the Excel-Link Ribbon Add-in follows the same steps except for the different file name (fp-excel-link-ribbon.xlsm) and Add-in item name (FusionPlace Excel-Link Ribbon). If you are registering a new version of *[Excel-Link] on a computer where an older version is already registered, please also refer to Procedures for Upgrading fusion_place, which describes important considerations.*
(Add-in Registration Procedure)
-
Click the “File” tab.
⇒ The menu is displayed on the left side. -
Click the Options button near the bottom of the menu.
⇒ The “Excel Options” dialog box appears. -
In the list on the left of the dialog box, click “Add-ins.”
⇒ A screen like the one below appears.
-
Click the Go… button at the bottom of the dialog box.
⇒ The “Add-ins” dialog box appears.
-
Click Browse… to open the “Browse” dialog box as shown below.
-
Copy or move the Excel-Link Add-in file (fp-excel-link.xla) to the folder shown above (you can also drag and drop it into the window).
-
Select the Excel-Link Add-in file (fp-excel-link.xla) in the above screen.
⇒ An item named FusionPlace Excel-Link appears in the Add-ins list (if not already present), and its checkbox becomes checked. -
Click OK to save the settings.
