To close all open tables:
- On the HOME tab, in the File group, click Close All. If you have edited one or more tables without saving before closing, a message displays for each table you edited prompting you to either save or discard your changes.
- Click Cancel to leave your pending edits unsaved and the table remains open.