Failed to open the target workbook. Make sure that the file has not been renamed or deleted

Product:
Planning Analytics 2.x

Microsoft Windows 2016 Server

Issue:
User have removed some sheet in a excel workbook and publish it again to TM1WEB.

But can now not open the application view in TM1WEB. User gets a error “Failed to open the target workbook. Make sure that the file has not been renamed or deleted”.

Solution:
Check the excel workbook for reference errors.
If there are formulas that referee to the deleted sheet, this can give this error.

Ensure that all formulas point to existing columns and sheets in the workbook.

Also ensure you do not have inserted unsupported object into the workbook, like word documents and links to pictures that may not work in TM1WEB.

Redo the workbook, and publish it again.

Also ensure you do not have empty columns on the right side in your spreadsheet, that can also affect TM1Web performance.

More Information:

https://www.ibm.com/docs/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ug.2.0.0.doc/tm1_ug.pdf

https://www.ibm.com/support/pages/list-microsoft-excel-supported-functionality-menu-ibm-cognos-tm1-web-net

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=reference-worksheet-functions

https://www.ibm.com/support/pages/how-hide-zeros-tm1web-websheet

https://www.ibm.com/support/pages/apar/PH17596