Makros not aktivating after saving on OneDrive

%3CLINGO-SUB%20id%3D%22lingo-sub-1436345%22%20slang%3D%22en-US%22%3EMakros%20not%20aktivating%20after%20saving%20on%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1436345%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EI%20saved%20an%20excel%20file%20for%20calculations%20on%20OneDrive%20with%20lots%20of%20markos.%20I%20bought%20this%20excel%20software%20externally%20to%20support%20my%20tax%20procedure%2C%20but%20unfortunatelly%20after%20re-opening%20again%20the%20file%20doens't%20work%20with%20the%20markos%20again.%20I%20also%20could't%20find%20a%20manuall%20re-activation%20for%20the%20markos%2C%20it%20just%20seems%20that%20they%20are%20completely%20blocked.%20This%20is%20crucial%20as%20in%20the%20other%20%22sides%22%20of%20the%20file%20I%20already%20saved%20lots%20of%20information%20and%20currently%20I%20hav%20no%20access%20to%20them%20at%20all%20any%20more.%20Can%20someone%20please%26nbsp%3B%20help%20me%20out.%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1436345%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1436573%22%20slang%3D%22en-US%22%3ERe%3A%20Makros%20not%20aktivating%20after%20saving%20on%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1436573%22%20slang%3D%22en-US%22%3EDoes%20it%20work%20if%20you%20save-as%20the%20file%20to%20a%20local%20folder%20on%20your%20PC%3F%3CBR%20%2F%3EPlease%20note%20that%20macros%20do%20not%20work%20when%20a%20file%20is%20opened%20in%20a%20browser%20window.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1436606%22%20slang%3D%22en-US%22%3ERe%3A%20Makros%20not%20aktivating%20after%20saving%20on%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1436606%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20already%20tried%20that.%20Downloaded%20the%20file%20and%20saved%20it%20locally%20on%20my%20Mac%2C%20no%20markros%20working%20either.%20Even%20no%20question%20asking%20during%20opening%20about%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1440165%22%20slang%3D%22en-US%22%3ERe%3A%20Makros%20not%20aktivating%20after%20saving%20on%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1440165%22%20slang%3D%22en-US%22%3EI'm%20no%20Mac%20user%20and%20I%20do%20not%20own%20one%20so%20it%20is%20hard%20for%20me%20to%20advise%20I'm%20afraid.%20Can%20you%20check%20in%20Excel%20options%20what%20your%20macro%20security%20is%20set%20to%3F%20Also%2C%20which%20exact%20version%20of%20Excel%20are%20you%20using%3F%20Excel%202008%20for%20Mac%20did%20not%20support%20VBA.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi all,

I saved an excel file for calculations on OneDrive with lots of markos. I bought this excel software externally to support my tax procedure, but unfortunatelly after re-opening again the file doens't work with the markos again. I also could't find a manuall re-activation for the markos, it just seems that they are completely blocked. This is crucial as in the other "sides" of the file I already saved lots of information and currently I hav no access to them at all any more. Can someone please  help me out. Thanks in advance.

3 Replies
Highlighted
Does it work if you save-as the file to a local folder on your PC?
Please note that macros do not work when a file is opened in a browser window.
Highlighted

@Jan Karel Pieterse 

Yes already tried that. Downloaded the file and saved it locally on my Mac, no markros working either. Even no question asking during opening about it.

 

Highlighted
I'm no Mac user and I do not own one so it is hard for me to advise I'm afraid. Can you check in Excel options what your macro security is set to? Also, which exact version of Excel are you using? Excel 2008 for Mac did not support VBA.