It was originally 10.7 and was upgraded in place to 10.9. Note that this MacBook Pro was setup via Migration Assistant from the 10.6.8 laptop it replaced. No longer complains about macros not being enabled. Opening the VBA interface works now too, and the workbook Fingers-crossed, I hit "Save." Boo Yaa, in 'yo face, point for me (it saved successfully).
launching an Office app and running the auto-updater).įinally, I launched Excel, answered the initial setup questions, and opened my shiny project dashboard file. I then reinstalled Office from my original media and manually applied updates to the latest version (vs. I skipped any steps that involved removing items that resided in my user home folder, or made reference to removing licensing components. I also noted these additional odd behaviors on the troublesome system: The workbook was alerting me that Macros were NOT enabled Opening the VBA interface caused Excel to CRASH.īased on these observations, I removed Office 2011 by PARTIALLY following this guide: How to completely remove Office for Mac 2011
The problem persisted, so I focused my attention on items outside my own home folder. With no apparent problems, I ruled out a 10.9.2 incompatibility as the cause.īack to my misbehaving MacBook Pro, I copied the file to /Users/Shared/ and opened it using a fresh user account.
I then opened the file on my 3rd machine (via DropBox), also running 10.9.2 and the same version of Excel. Since I also have a hyphen in the name of my 10.6.8 drive, I gave that a very low causal score. I have no oddities in how my permissions are set on my drive and no naughty file names, excepting a hyphen in the root drive's name. xls option wasn't an option for this document. I noted that a temporary file briefly appeared in the destination folder when I attempted a "save as." but the error still appeared. When I tried to save the document, I received the dreaded I opened the same file from my DropBox folder, clicked the enable macros button, and entered some data. I went home and opened my Mavericks-running (10.9.2) i7 MacBook Pro with the same Excel version. The file is living in a DropBox folder that is shared among 3 computers. I began entering my data into this workbook using a 2008 MacPro running OS X 10.6.8 and Excel 14.4.1. The workbook (.xlsm) requires macros and VBA, has multiple sheets (some protected), and clearly lets you know if Macros are disabled. I purchased a rather elaborate project dashboard workbook from.
I'd like to share my experiences and solution in hopes that it will work for others. I've read this thread with great interest.
0 kommentar(er)
