Can not select save format on excel for mac

broken image
broken image

I'm a bit 'stuck' on what the issue might be.

broken image

I can work around the issue just by copying the contents of the 'grayed' files into a new document in TextWrangler and saving it, but I'd like to understand the reason for this behavior.ĭoing a file in the files in question shows them to be similar if not the same: Mac:samples jjarava$ file 201507*txtĢ0150728 - Source Fragment 3.TXT: ASCII textĢ0150728 - Source Framgent 1.TXT: ASCII textĢ0150728 - Source Fragment 1.TXT: ASCII textĢ0150728 - Source.TXT: ASCII text, with CRLF line terminatorsĢ0150728 - Source Fragment 3 copy.TXT: ASCII text

broken image

The only 'logic' is that the 'source' file (let's call it 20150728 - SOURCE.TXT) comes via email from a Windows machine, and the two other locked files ( 20150728 - Source Fragment 3.TXT and 20150728 - Source Fragment 3 copy.TXT) are a copy of the Source where I've deleted some lines, and a second copy of the resulting file, while the non-locked ones started out as the Source where I deleted lines, and then did a 'Save As' in TextWrangler. There are no differences between the files that I can see that would justify the difference. Like as I've done many times in the past, I get the 'Choose a File' Dialog Box, but when I browse to the folder, only a couple of the files are 'selectable' the others are 'Grayed out': When I'm trying to import them via Data > Get External Data > Import Text File: I'm using Excel for crunching some data I have in several.