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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies