A true pain in the ass, sometimes... This thread contains two other suggestions that might help: Save Workbook failed: Internal Error - An unexpected error occurred and the operation could not be completed.
- Sankar Rajan: Right click (one or multiple) sheets/dashboards and use the "Export Sheet" functionality to save them somewhere else. Recombine afterwards, when possible.
- James Patterson: Unhide all worksheets, and remove all dashboards from the workbook, then save.
Hope this helps some people out...
I have exactly the same issue and I think it is also related to parameters conflict between saved or published datasources and those created with workbook. Saving, exporting or publishing ends with the same error.
Parameter saving is kinda messy at the moment and I sometimes ends up with 3 same named parameters but with only one working properly for any given worksheet or dashboard. Only way to distinguish them is to rename them and then check which one is correct. Problem is that after save and reload they reappear.
I renamed all Dashboards Sheets and it worked like magic.added a space at the beginning.
The reason i think is if you are copying a view/Dashboard from a different report to an existing report with the same name , by Default tableau creates a new name appending "XXXX(2)" , but the meta data might have been corrupted.