When a single Excel worksheet has multiple Board Tables, there must be enough space already reserved in the worksheet to accommodate the size of each Board Table. Tables overlapping another table, formula, or other cell content is not supported.
Enough range for a Table is critical both for retrieving the data for the first time when they are created, upon refreshing the retrieved Board data after interacting with a Table or manually refreshing via the Refresh buttons, or when expanding row groups. There must be sufficient empty rows and columns without interfering with any other Table or other values in the worksheet.
This applies equally to creating a new Table, expanding an already existing Table caused by a Selection change, pasting a previously saved and copied Table, and refreshing a Table from the Board data sources. If the target range is not large enough, the Table will not paste, load, or be created and a warning message appears asking the user to find an area with more space to accommodate it. The error message provides the range information needed for the Tables to avoid overlap.
.png)
.png)
When does overlap happen?
Table overlap can happen in the following situations:
Creating a Table
Pasting a Table
Changing a selection
Pivoting data differently
Expanding rows in a Table above another Table
Refreshing a Table which now has more data than before
How to fix Table overlap
To fix the overlap, you have 2 options:
Add the necessary rows and columns in the same area by using the "Insert" feature from Excel's Home tab under "Cells".
Move the Table from the Table configuration area of the right panel:
Click on the Table that is restricting the other Table from overlapping and access the Table configuration area in the right panel.
In the “Position” field, edit the position formula to move the Table according to range information given by the error message.
Then, try again: paste Table, expand rows, or create Table, and always refresh.
Overlap behavior
By design, the Add-in downloads the new data but does not print it if an overlap occurs. If you make changes in the sheet to make room for the Table, the data prints as if the overlap did not occur, and you do not need to run a full refresh after an overlap message appears.
This means that after an overlap message appears, if you make a change not affecting the overlap before making room for the Table to print, the first change may be ignored.
For example, if you remove a selection of a Table without enough room causing a Table overlap, then you add the selection back and move the Table so there is enough room, the Table without the selection is printed instead of with the selection.
The recommended best practice is to make room for a Table if an overlap occurs, then continue working with the Table.
Board M365: Table Best practices
Board recommends the following best practices to avoid Table overlap:
Keep the number of Tables per Worksheet to a minimum, ideally one.
When an overlap occurs, address the issue by creating enough room for the Table to print before continuing anything else.
Avoid hiding or grouping rows and columns that contain Board Tables or formulas.
This can complicate the use of Tables and make the resolution of potential Table overlap conflicts more difficult to resolve.