Cannot be answered or removed

%3CLINGO-SUB%20id%3D%22lingo-sub-2587057%22%20slang%3D%22en-US%22%3EFormat%20as%20a%20Table%20will%20NOT%20Format%20as%20a%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2587057%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20Excel%20spreadsheet%20that%20I%20created%20with%20imported%20data%20(Data%26gt%3BFrom%20Text%26gt%3BSelected%20.txt%20File).%20Removed%20the%20external%20connection%20to%20the%20.txt%20file%20by%20deleting%20it%20using%20the%20Name%20Manager.%20Added%20headers%20and%20tried%20to%20format%20as%20a%20table%20(Home%26gt%3BFormat%20as%20Table%26gt%3BTable%20Style%20Medium%2020).%20Excel%20opens%20the%20%22Format%20as%20table%22%20wizard%20and%20automatically%20puts%20the%20dashed%20lines%20around%20all%20the%20headers%20and%20data.%20I%20checked%20the%20%22My%20table%20has%20headers%22%20box.%20Then%20I%20hit%20OK.%26nbsp%3B%3C%2FP%3E%3CP%3ENothing%20happens.%20The%20Format%20as%20table%20box%20stays%2C%20the%20data%20stays%20with%20the%20dashed%20lines%2C%20but%20I%20do%20not%20get%20a%20table.%20I%20don't%20get%20the%20spinner%2C%20only%20my%20data%20with%20a%20dashed%20line%20around%20it%20and%20a%20Format%20as%20table%20box%20asking%20OK%20or%20Canclel.%3C%2FP%3E%3CP%3E%26nbsp%3BExcel%20has%20formatted%20tables%20for%20me%20under%20these%20conditions%20before%20so%20I%20don't%20understand%20why%20this%20is%20not%20working.%26nbsp%3B%20I%20am%20using%20MS%20Office%20Professional%20Plus%202016.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2587057%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2587410%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20as%20a%20Table%20will%20NOT%20Format%20as%20a%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2587410%22%20slang%3D%22en-US%22%3EWhat%20if%20you%20do%20not%20remove%20the%20connection%20first%2C%20but%20convert%20to%20table%20directly%20and%20click%20Yes%20to%20accept%20the%20removal%20of%20the%20connection%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2594602%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20as%20a%20Table%20will%20NOT%20Format%20as%20a%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594602%22%20slang%3D%22en-US%22%3EStill%20does%20not%20work.%3C%2FLINGO-BODY%3E
New Contributor

I have an Excel spreadsheet that I created with imported data (Data>From Text>Selected .txt File). Removed the external connection to the .txt file by deleting it using the Name Manager. Added headers and tried to format as a table (Home>Format as Table>Table Style Medium 20). Excel opens the "Format as table" wizard and automatically puts the dashed lines around all the headers and data. I checked the "My table has headers" box. Then I hit OK. 

Nothing happens. The Format as table box stays, the data stays with the dashed lines, but I do not get a table. I don't get the spinner, only my data with a dashed line around it and a Format as table box asking OK or Canclel.

 Excel has formatted tables for me under these conditions before so I don't understand why this is not working.  I am using MS Office Professional Plus 2016.

5 Replies
What if you do not remove the connection first, but convert to table directly and click Yes to accept the removal of the connection?
Still does not work.
Can you please upload just the sheet with the table? You can clear all rows of data but only leave the header row in place before uploading, I do not need any data but the header.
How can I remove this question as it seems no one has had this experience before? My employer does not permit posting of any spreadsheets no matter how much has been "removed."
I don't see much reason to delete the question, it does not appear any sensitive information has been shared?