Trouble creating feeds in Excel
When creating a feed in the Excel add-in, you may receive an error message similar to the following:
A table cannot overlap a range that contains a PivotTable report, query results, protected cells or another table.
Cannot use this table functionality on a protected worksheet.
Data Everywhere uses Excel Data Tables to keep track of the location and data contained within feeds. This error can occur in a few different scenarios:
- If you are already using data tables in your spreadsheet, please use the existing table to create a feed or expand the table to include all the data you want to share.
- Creating a feed from protected cells is not supported. However, this can be worked around by unprotecting the worksheet, creating a data feed, then re-protecting the worksheet.
- Currently, sharing pivot table results via a feed is not supported. If this is something you are looking for, please contact us and let us know.
If you are using Excel AutoFilters, you may see an error message similar to the following:
This operation is attempting to change a filtered range on your worksheet and cannot be completed. To complete this operation, AutoFilters in the sheet need to be removed.
This error message indicates that an Excel table cannot be created when AutoFilter is enabled. To work around this issue, simply turn auto-filtering off on your worksheet, create the Data Everywhere feed, and then use the filtering provided by the Excel data table instead.