I have imported a number of worksheets from a Excel workbook in .xlsx format and made them linked to this workbook. When the workbook is opened, it allows me to update the imported tables and open them. However, when I close the workbook, I cannot open the tables again and a message "External table is not in expected format" comes to to screen.
I want to work on those imported tables without openning the sourced workbook. How can I do that? Please help.
Bookmarks