One can use Copy > Paste Special (Values Only) in Excel to copy over table views without the underlying data connections, pivot tables and formulas and so on.

Like the above, can one use Python to save a copy of a worksheet without the values, while keeping the formatting? If so, how? shutil just duplicates the file with all the aforementioned properties included.

The purpose of this is to archive historical reports, while disabling any way to refresh the data that could potentially break the purpose of it being historical.