Comments on this post: Excel cell contents not visible - but show in formula bar and print preview # re: Excel cell contents not visible - but show in formula bar and print preview We just experienced this with Excel 2008 on Leopard - both fully patched.

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 File>Open 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.

However, it has some features that other programs don’t have, like audio splicing and automatic video splicing. Hyperengine AV Much like CineFX, Hyperengine AV is both free and very easy to use, which makes it another excellent beginner program. If you purchase a license, you unlock a lot more features on the program. It was also based upon the open source program Jahshaka, which means you’re sure to get a great experience out it. What is the best movie making software for mac. This is all done with a drag and drop interface.

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.

I am using Mac 10.8.4 and Excel 2011 (version 14.3.9) with no recent upgrading that I recall. Docker for mac. All work done on MacBook Pro so files are not stored elsewhere. I use many very basic Excel worksheets, some still using XLS and some using XLSX file types. Today I go to open a XLS file that I've used within past 2 weeks, and it will not open.

I am not having issues opening XLSX (or the ones I have selected at least), but do not see to be able to open XLS files as of today. The dialog I get is: 'filename'.xls c annot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding. I cannot open Original, I cannot open a Copy. I have checked the Get Info and my permissions have not changed.

I have Read and Write permissions. I am stumped as to how to proceed to open any of these troubled files. I assume that once I figure out how to open and should Save As with the XLSX file type. Hi Sorry I didn’t notice your reply before now. It appears the problem on your Mac does not lie with preference files.