# Gotchas & Known Limits

Limitations and recovery advice now live with their owning topics:

- [Ranges](range.md) for dates, identifiers, and merged cells
- [Power Query](powerquery.md) for loading and refresh
- [Data Model and DAX](datamodel.md) for model prerequisites
- [PivotTables](pivottable.md) for calculated fields, grouping, and refresh
- [Working safely with Excel](behavioral-rules.md) for session failures