The Get Info window shows the file path Switch to Column view: you can see the file’s path by the columns to the left of it. Select the file and choose Get Info from the File menu. The Info window opens. In the General section of the Info window the Where item shows the file path. So next time you can see a file but you’re not sure where it is exactly just glance down at the Path Bar if it’s displayed, or use one of the other methods I’ve mentioned above.
Learn how to install an Excel add-in file (.xla or.xlam) on Excel 2011 for Mac. The add-in file should now appear in the list of available add-ins in the Add-Ins. Enabling file access on Excel 2016 for macs. In the 2016+ versions of Excel, VBA operates in a sandbox which means that explicit permission has to be granted if any files are to be opened. This is not required if the file has been identified with a appleScript 'fileopen dialog box.
Did I miss any possibilities? Let me know in the Comments below. Brian Forbes said: I just bought a Mac and can tell you that the ridiculous amount of clicking just to locate and save files is a HUGE TIME WASTER. Under Windows, I had an explorer (finder) window open with a path to a folder that I needed to open from and save to while moving between programs. It was this simple, copy the path, save from the program, paste path into the name field, hit enter, guess what?
I’m in the right folder and I just hit save. If I didn’t copy or paste anything in a program, then the path remained on my clipboard – too easy. So this is totally cracked out and should be fixed. Btw 10.6.x there is no “show path” option.
said: Ryan wrote: “Another thing. When the hell are they going to put a “show desktop” button to minimize all windows.
Seems like a very simple thing that they forget in all new versions of macs.” Why do you want to minimise all windows Ryan? If you want an ‘uncluttered’ view of the Desktop press F11 to move all windows out of the way. They all ‘minimise’ themselves to the sides of the screen. Press F11 again to bring them back. Remember that if you’re using a laptop you may need to also press the fn key, depending on the settings you’ve chosen in System Prefs. To go directly to a directory while an Open or Save dialog is open – eg to go directly to /Documents/iChats – press Command Shift G.
A text area appears where you can type or paste an address, such as /Documents/iChats. Press the Go button and there you are. I hope that helps. said: Well, there’s one sneaky, but easy way to do it. Have the enclosing folder open in Finder.
Open Terminal (in Applications – Utilities). Drag the file whose path you want to copy into the open Terminal window. The path is entered for you. For example, I dragged About Stacks.pdf from my Documents folder into a Terminal window.
This was what I saw: /Users/miraz/Documents/About Stacks.pdf Another option involves buying and installing the most excellent Finder replacement called PathFinder. Control Click on a file and choose from the Contextual menu to Copy Path. You’re given a choice of 6 different formats, including Unix, HFS and so on. PathFinder is totally worth it for many other reasons, but if you often need to copy a file path, then it would be a good choice. You know, there’s probably also an Automator action you could set up Cheers, Miraz.
Here are the solution steps:. Go to Library Application Support Microsoft Office Office 2011 AutoRecovery in Finder (on OSX10.7+ this may first require making the Library directory visible using one of the methods described or ). Change the Extension of the Excel autorecover files of interest from.xlsx to.xlsb. Open the files with Excel (either double click or using Excel's FileOpen menu). Enjoy!
Discussion: As described in, if you are lucky, a newer auto-recovery version can often be found in Library Application Support Microsoft Office Office 2011 AutoRecovery. Files in this directory often have somewhat munged/cryptic names, but you can always open them up to find the best one. However, in the current version of Excel for Mac 2011 (14.3.1, maybe others) there is a bug that prevents easily opening these backup files. Specifically, the filenames are listed with an.xlsx extension (corresponding to Excel XML format), but are actually in a different format.
As a result attempting to open them in Finder or through the Open menu fails, claiming the files are corrupt. The exact error is Microsoft cannot open this file The file format or file extension is not valid.
Verify that the file has not been corrupted and that the file extension matches the format of the file. Changing the file extension to.xlsb (Excel binary format) or.xlk (older Excel backup) will allow Excel to open the file. My file system structure turned out to be a little different than that suggested in Bryan P's excellent answer (no Microsoft in Application Support), and I couldn't search for file name since search doesn't work for hidden files. Luckily, there is a tool called.
It does not use a database but instead uses the file system driver's fast search operations, where available I was able to use the program to search my whole HD for a word in the title of my lost Excel file, and I found a suitably up-to-date version of the file. I highly recommend using the app to find what OS X deosn't want to show you.