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. This is critical both for retrieving the data for the Tables the first time that they are created, and upon refreshing the retrieved Board data after interacting with a Table or manually refreshing via the Refresh buttons. 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
Expanding rows in a Table above another Table
Refreshing a Table which now has more data than before refresh and exists too close to another Table
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".
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, refresh Table, or Create 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
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.