I just got a file from my colleague which has some broken links. They were broken because the path to the cells pointed directly to a file on her computer. She sent over those files, and now I have to repair the links. Hp officejet 7210 software for mac. However, Excel won't let me choose to change source to those new files. It will let me choose to replace the source with some other Excel files, but the ones I want are greyed out. How do I make it so Excel will let me use those files as source?
Active3 years, 7 months ago
Why Is Insert Greyed Out In Excel![]()
Jarrett G.Jarrett G.
2 Answers
VBA Editor References Option is Grayed Out. As per the link the solution is below. This normally should not occur as there is not a setting in the VBA editor to turn off access to references. To correct this problem, first save the VBA customization and then shut down the VBA editor. Restart the VBA editor and go to Tools| References. Mine does that every time that I have: A. Opened Excel B. Opened the VBA Editor C. Closed the VBA Editor D. Locked Windows (Windows Key + L) When I then log back into Windows, the VBA Editor will be open but with no toolbars. Purity kateiko utao audio download.
I had this same problem with files that were being shared via Google Drive. The solution that worked for me was: Dmg os x yosemite.
I want to add the Data Pack for Excel 2011, but the Add-ins menu option on the Tools menu is greyed out. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. The screenshot shows the general options for working with Excel, independent of any files. If you cannot edit a workbook, check if the workbook structure or the sheets are protected. Review ribbon > Unprotect.
![]()
Have tried this with Excel 2008 and Excel 2011. 2011 was on Yosemite. Connect zte to mac download photo.
worldofchrisworldofchris
Excel Vba Editor Download
It might be that the files don't have a proper extension? Besides, you can manually edit the formula, and type in the full path to the desired files. Ideally, you should use a relative-path form: see, for instance the answer here.
Community♦
juandesantjuandesant
Not the answer you're looking for? Browse other questions tagged macosmicrosoft-excelmicrosoft-officemicrosoft-excel-2010microsoft-excel-2011 or ask your own question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |