Home

Macro-Enabled Excel file not working when sent to colleagues in .xlsm format

%3CLINGO-SUB%20id%3D%22lingo-sub-727759%22%20slang%3D%22en-US%22%3EMacro-Enabled%20Excel%20file%20not%20working%20when%20sent%20to%20colleagues%20in%20.xlsm%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-727759%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20created%20a%20relatively%20basic%20Excel%20spreadsheet%20which%20contains%20Macros%20that%20were%20created%20within%20the%20worksheets.%20All%20calculations%20and%20macros%20were%20working%20perfectly%20and%20with%20some%20pride%2C%20I%20saved%20the%20file.%20However%2C%20Excel%20requires%20that%20the%20file%20format%20is%20converted%20to%20.xlsm%20(macro%20enabled).%20So%20I%20naturally%20'went%20with%20it'%20and%20selected%20the%20.xlsm%20extension.%20%26nbsp%3BWhen%20returning%20to%20the%20file%20a%20little%20later%2C%20excel%20couldn't%20open%20the%20new%20file!!%20After%20a%20few%20fiddles%20with%20the%20'properties'%2C%20I%20managed%20to%20get%20the%20thing%20open%20and%20with%20a%20few%20more%20fiddles%2C%20managed%20to%20resolve%20the%20'error%20messages'%20that%20had%20magically%20appeared.%20So%20all%20good%20on%20MY%20computer%2C%20but%20when%20I%20send%20the%20file%20to%20collaborating%20colleagues%2C%20they%20are%20experiencing%20difficulties%20in%20that%20the%20cells%20containing%20calculations%20are%20not%20working.%20I'm%20sure%20I%20will%20not%20be%20the%20first%20to%20have%20experienced%20this%20problem%20and%20hope%20that%20someone%20far%20more%20intelligent%20out%20there%20may%20have%20a%20solution%20to%20this.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-727759%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-728096%22%20slang%3D%22en-US%22%3ERe%3A%20Macro-Enabled%20Excel%20file%20not%20working%20when%20sent%20to%20colleagues%20in%20.xlsm%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-728096%22%20slang%3D%22en-US%22%3EIs%20calculation%20set%20to%20manual%20perhaps%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-731436%22%20slang%3D%22en-US%22%3ERe%3A%20Macro-Enabled%20Excel%20file%20not%20working%20when%20sent%20to%20colleagues%20in%20.xlsm%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-731436%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%20Sorry%20for%20delay%20in%20getting%20back%20to%20you%20-%20No%2C%20all%20set%20up%20for%20Automatic%20calculation%2C%20but%20thanks%20for%20the%20thought!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-731587%22%20slang%3D%22en-US%22%3ERe%3A%20Macro-Enabled%20Excel%20file%20not%20working%20when%20sent%20to%20colleagues%20in%20.xlsm%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-731587%22%20slang%3D%22en-US%22%3EWhat%20kind%20of%20difficulties%20are%20your%20colleagues%20experiencing%20precisely%3F%3C%2FLINGO-BODY%3E
marineman012
New Contributor

Hi, I have created a relatively basic Excel spreadsheet which contains Macros that were created within the worksheets. All calculations and macros were working perfectly and with some pride, I saved the file. However, Excel requires that the file format is converted to .xlsm (macro enabled). So I naturally 'went with it' and selected the .xlsm extension.  When returning to the file a little later, excel couldn't open the new file!! After a few fiddles with the 'properties', I managed to get the thing open and with a few more fiddles, managed to resolve the 'error messages' that had magically appeared. So all good on MY computer, but when I send the file to collaborating colleagues, they are experiencing difficulties in that the cells containing calculations are not working. I'm sure I will not be the first to have experienced this problem and hope that someone far more intelligent out there may have a solution to this. 

3 Replies
Is calculation set to manual perhaps?

@Jan Karel Pieterse  Sorry for delay in getting back to you - No, all set up for Automatic calculation, but thanks for the thought!

What kind of difficulties are your colleagues experiencing precisely?
Related Conversations