Microsoft Visual Basic

Question

I use the financial return template from HK regulator, SFC.

When I complete and save as a read version only, an error box like this

How to fix it?

Answer 1

You have to save it as "Excel-Workbook with Macros" = .XLSM, otherwise the macros will be removed.

Answer 2

Hi @tingkong so

Have you tried to save your file as .xlsm?

Besides, does this issue occur before?

If conditions permit, it is recommended that you go to another computer and use a different version of Excel to test it.

I download the template, and save it as a .xlsx file, there is no error message like yours. (Because I'm not a professional in financial return, I didn't enter much data. In My environment, I use Excel for Microsoft 365, Version 2311 (Build 17029.20108))

From a software perspective, it is recommended to update Office to the latest version first to have a check at present.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---