Running inventory count - even when clearing linked worksheet

This may be impossible. My son uses a spreadsheet with inventory counts. The inventory counts are linked to another worksheet for a particular customer project. He wants to be able to clear the custo...