Forum Discussion

AV2021's avatar
AV2021
Copper Contributor
Jan 16, 2021

Macroenabled Excel File

Hi there, am unable to save a macro-enabled excel file 

saving it correctly as .xlsm file but error pops up 

please help

all my colleagues could save it but am unable to do so 

excel
Macros and VBA

5 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jan 16, 2021

    AV2021 

    Many possible sources of error:

    For example, it could be write-protected or a file with old Excel format.

     

    However, it is good if you insert a file (if possible without sensitive data, please) where this error occurs. This is the best way to identify the source of the error and offer you the best possible solution.

     

    Thanks in advance for your patience and time.

     

    Nikolino

    I know I don't know anything (Socrates)

    • AV2021's avatar
      AV2021
      Copper Contributor
      Jan 16, 2021
      Hi Nik, thanks for looking into it.
      How to insert a file into an excel file?
      This file can not be saved as simple excel file so I can’t choose anything other than macro enabled excel and it should automatically take it.
      I wonder why the error reads ‘ it can save without some features”??
      What is the latest edition of excel provided by Office? If you share that too, will inform the creator of the file to check that at his end
      • NikolinoDE's avatar
        NikolinoDE
        Platinum Contributor
        Jan 16, 2021

        AV2021 

        Writing in English was never my forte, so I always recommend that a file (without sensitive data) can help much better.

        In order not to write down every single step and especially the possibility of the source of the error.

        I recommend uploading a file (without sensitive data). Thank you for your patience and time.

         

        Thank you for your patience and time.

         

        Nikolino

        I know I don't know anything (Socrates)

Resources