Update or Overwrite a Published Hyper File Error "Cannot replace the extract file which is currently in use"

When Hyper files are published and shared on Tableau Server, an error will occur when trying to update (overwrite) the Hyper file using Tableau Desktop or Tableau Prep Builder stating:

Cannot replace the extract file which is currently in use.  Please choose a new location to save the extract.
or
Unable to generate output.  The output file is in use. Close the file and try again.

When using workbooks that directly access Hyper files in shared network folders, updating these Hyper files in place is not a supported scenario.

Cause

• Hyper locks databases/extracts, when Tableau Server utilizes them. It is not possible to directly control how long the lock is held because Tableau Server keeps sessions open.
• Even if successful in updating the Hyper file without any locks being held, Tableau Server caches to not take the in-place updates into account. Therefore, when accessing views on Tableau that utilizes the Hyper file, there may be outdated data from Tableau Server's cache. Tableau Desktop, on the other hand, behaves differently with its caching and is more likely to detect when the file has been changed.