Mac Excel Can T Find Project Or Library
Macs are not perfect even though one’s productivity is much higher with one. When things go wrong – they can sometimes really go wrong.
One customer had issues with a critical branding font that installs fine on everyone else’s Macbook but not theirs. I now know more about fonts that I ever wanted to know especially how Microsoft fonts fit into the Mac picture. I researched dozens of websites each adding a piece to the puzzle. Here we go …
- There are 4 font stores on your Mac
- user fonts stored in /Users/youraccount/Library/Fonts
- computer wide (all accounts) fonts in /Library/Fonts
- system fonts in /System/Library/Fonts (never ever touch these)
- Microsoft Office fonts in /Library/Fonts/Microsoft (ahhh I see)
- ONLY TTF fonts work for Office – or so MS claims
- To install fonts for MS Office 2011 – don’t double click them – this installs them naturally in the user fonts
- instead – start up Font Book (use the spotlight or magnifying glass to find it quick in the upper right of your Mac)
- drag them from your Finder onto Computer (under the Collection section at the left of the Font Book app)
- A reboot triggers the Mac Font store to sync with Office. Don’t forget to reboot before ripping your hair out
- Adding fonts to the user fonts will never show up in Microsoft Office products
- Don’t assume that because a font works in lets say Word, that it will appear in Excel – it might once the cache catches up
- Microsoft font cache file can be delete so it will force a refresh – but it can be in 2 places – check both. Microsoft moved it for Office 2011 for Mac for some computers different than others
- Lion? goto finder and hold the option key and …
- click the menu Go->Library or type in a folder /Library by choosing the Go->Go to Folder option then navigate eventually to /Library/Preferences/Microsoft/Office 2011
- not there? Microsoft moved them in later releases of Office 2011 to /Library/Application Support/Microsoft/Preferences/Office 2011 – even MS’ articles are incorrect!
- also you might need to look in /Users/yourname/Library/Application Support/Microsoft/Preferences/Office 2011
- when you re-start work or Excel you will now see a task completing to rebuild the cache files and if you observe the location above you will see new cache files
- Here is a link to completely remove Office on a mac and is the final puzzle piece that allowed me to solve this riddle http://support.microsoft.com/kb/2398768
Mac Excel Can T Find Project Or Library Catalog
Preview the repaired excel file in real-time,see how much of the file has been recovered as it is being repaired. All kind of MS office corruption errors (for XLS and XLSX files only) can be handled with this tool. This excel file repair tool can be used on both windows and Mac platforms in. Mar 01, 2016 “Excel cannot open the file “, because 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. “Can’t find project or library. Microsoft Excel is restarting.” The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt.
May 22, 2019 It is really frustrating and you may want to find a way to recover Excel not saved on mac just like George. Well, by following the guide below, you. Problem: When using the VBA Code or Macros in Microsoft Access or Excel, the following errror is received “Compile Error: Can’t find project or library”.
Need some help. I keep getting the Can't Find Project or Library error on a spreadsheet that was NOT written in VBA. I looked it up and reference. Nov 15, 2005 Post subject: Re: ERROR - Compile Error, Can't find project or library: Hi All, I think I had to just open the VBA Code and click on Tools and References from the VBA Menu and Check on adding Miscrosoft libraries. I had to uncheck the MISSING one. It worked fine after that.
Can't Find Project Or Library Vba
Many thanks to these sites:
Google assistant library machine. Jul 04, 2017 Mac Assistant runs in the menu bar. The first time you click the menu bar icon, you’ll be asked to sign into your Google account. After that, you’ll see a microphone in the pop-up window. Tap it to start talking to Google Assistant. You can also trigger the. Issa Rae is bringing her voice to your Google Assistant. You can hear Issa Rae answer your questions, tell you about the weather, offer words of inspiration and more, while the regular Assistant voice handles the rest. Just say “Hey Google, talk like Issa” to get started.