Link to Excel data

Your map can include topics that link to and display Excel data. You can establish the link to the data from either MindManager or Excel.

Link to Excel data from Excel

1. Highlight a range in the Excel worksheet.

2. Click the Link Range to Mindjet MindManager button in the standard toolbar, or on the Excel 2007 Ribbon's Add-ins tab.

If MindManager is open a new topic is added to the current map as either a main topic (nothing selected) or as a subtopic of the currently selected topic. The new topic contains the worksheet data.

If MindManager is not open, it opens and begins a new map with a main topic that contains the worksheet data.

•  If you do not see the Link Range to Mindjet MindManager button in Excel, see Troubleshooting Office add-ins.

Link to Excel from MindManager

1. Optional Select a topic. A new subtopic will be created with the data

2. Do one of the following:

• On the Insert tab, in the Microsoft Excel group, click the Microsoft Excel Range.

• On the Tools tab, in the Templates group, click Map Parts, or on the Status Bar, click Task Panes, then click Map Parts.
  In the Map Parts task pane, under Map Parts, click Microsoft Excel Linker, then drag the Range topic to the map.

•  If you do not see the Microsoft Excel group on the Insert tab or the Microsoft Excel Linker in the Map Parts pane, see Troubleshooting Office add-ins.

3. If Excel is not open it will start and prompt you to open a worksheet. Otherwise, it displays the current worksheet.

4. You will be prompted to highlight a data range in Excel. Highlight the range and click OK.

• You can modify the selected range later, if you wish.

5. Switch back to MindManager. You'll see the Excel data included as a spreadsheet on a new topic.

• If only a portion of your data is shown you can re-size the spreadsheet as described above.

6. You can close Excel at any time. You will be prompted to save the worksheet to save the MindManager links.

• MindManager does not support Excel formulas.

Resize the spreadsheet

Initially, you may only see a portion of your data. To see all the data, you can resize the spreadsheet.

1. Select the topic then click again to select the spreadsheet.

2. Use the corner handles to resize the data area.

• MindManager displays the data as shown in the spreadsheet - its formatting, row height, and column widths are determined there.

Modify the selected range

1. Right-click the topic's Microsoft Excel icon.

2. Click Update Microsoft Excel Range.

3. Excel will open and prompt you for the new range.

Disconnect data from Excel

You can disconnect the map spreadsheet from Excel - this breaks the link but the data remains in the map as a MindManager spreadsheet. Changes to the data in MindManager will no longer affect the Excel spreadsheet and vice-versa.

Disconnect the spreadsheet data

1. Right- click the Microsoft Excel icon on the topic.

2. Click Disconnect from Microsoft Excel.

The data is retained in the map as a spreadsheet.