I have been battling to open websheets in TM1Web and embed them into PAW.
When I open any workbook, even one with a single cell with TEST PASS in A1, I receive the message:
Workbook error Failed to open target workbook. Make sure that the file has not been renamed or deleted.
There is little to nothing on this error other than an issue in the code which was addressed years ago.
My installation is a fresh install of PAW 2.0.101 and PASS 2.0.101, on Linux
Focusing only on PASS/TM1Web, I can log in, open views etc. but as soon as I open a workbook from applications/content store I get the message.
What is strange is I can see the book partially i.e. the outline of my cell A1 but no message.
For other books, I can see the tabs at the bottom and can click them but no content.
Opening a network trace gives me status codes of 200 throughout all the objects and I can see the CSS file being retrieved which I am assuming should be rendered.
If I open the CSS file which is named something like s_174196..._f.css I can see the text and it looks to be complete as it ends with a }, not in the middle of code.
I also do not see and Statuses of Pending or anything else untoward.
I have tried opening content across Chrome, Edge and Firefox and get the same results and network tracing shows the same with no obvious errors.
The excelsheet directory seems fine as with each attempt, a new folder is created with 3 CSS files.
I created a HAR file with some test cases and cannot pick up anything that looks like an obvious abort, error, exit but not 100% sure exactly what to look for in 40k lines.
Any ideas on how to resolve this would be greatly appreciated. I also have an open a support ticket on the go.
TIA!