On Dec 16, 2017, at 2:00 PM, Chip Scheide wrote: > Got a file which claims to be an excel file (.xls) but will not open as > an excel spreadsheet (Mac Office 2011 Excel) > When the file opens in excel, it is opened as if it was a plain text > file, when opened in Windows Office 2010 Excel it opens, and opens as a > spread sheet. > > Anyone have any ideas on how to open this type of file in Excel (Mac)
I think this is a Excel Windows only feature. I have a client that does this now. I create a text file with the “.xls” file extension and they can just double-click it and it opens in Excel without showing the import dialog. It seems the Windows version Excel will do some introspection when it attempts to open a file with “.xls” extension and can deal with many different text documents doing an “auto import” for you. I’m guessing this as a feature requested by the corporate IT types long ago so they could dump out data from databases in text format and have their users easily open them in Excel. It macOS version of Excel used to do this but it appears they have removed that feature. Tim ******************************************** Tim Nevels Innovative Solutions 785-749-3444 [email protected] ******************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
