Fri 19 Aug 2005
This one’s for Karen.
We’ve experienced issues with trying to open files in Excel that we know should open. The common example is with csv files. Say we have a file named data.csv that we wish to load into Excel. We choose to Open a new file. At the top of the window is a drop-down selection menu to Enable certain files. The default choice is “All Readable Documents”. This choice is no good, however, as our data.csv remains faded in the finder window, and we are unable to select it.
At this point, our normal workaround is to add a.txt extension to the file, so that data.csv becomes data.csv.txt. This activates the file in the finder window, giving us the ability to open it. This workaround, while trivial, is tedious (when dealing with lots of files) and also unnecessary.
Instead of changing file names, you can change the Enable drop-down menu to “All Documents”. The data.csv still remains faded in the finder window. However, it is now selectable and can be opened in Excel, without a .txt extension.
In my opinion, this is a poor design of the application interface. Faded file names usually means that a file is not selectable. When enabling “All Documents” in the Open window, the data.csv text should appear activated as a visual cue that I can now select on that item. (Note: The icon of the data.csv file does appear activated at this step. It is only the file name text that remains faded).
One Response to “Open Any Document in Excel (on Mac)”
Leave a Reply
You must be logged in to post a comment.


August 23rd, 2005 at 10:49 am
A gem! An example of how the minor documentation-glitches or design-misfeature mysteries - for which we use work-arounds for months or years - represent major break-throughs. Thank you.
Makes my all time favorite category the well-named ‘hints’.
-ksb