I created a multi-sheet workbook with multiple tables and a pivot chart on the computer. When I try to open that workbook in excel on my tablet however, it keeps giving me an error saying that it can't open workbooks with text queries. I clicked on the "connections" button and deleted all of the connections (I used .csv file to import some data) but it still wouldn't open. The "properties" button underneath the connections button was greyed out after deleting connections, so I created a new connection, clicked on "properties", unchecked "save connections", reopened "properties", and verified that all connections were deleted. After all of that, I saved the entire thing under a new name and tried opening it on my tablet and got the same text queries error.
Is there any solution to this other than to copy and special paste multiple times and lose half an hour of work creating the same product that I already have?
Is there any solution to this other than to copy and special paste multiple times and lose half an hour of work creating the same product that I already have?
