Unable to open excel macro 2003 with excel 365 for business

Question

Hi support team, 

My excel 2003 file with macro cannot run on excel 365 for business. I do enable macro on excel 365 but worksheet window is backlit and an error "excel cannot open two workbooks with the same name at the same time" occur when I run the macro. My 2003 macro file works well with excel 2010.

Thanks,

Nguyen

Answer 1

Hi ntnguyen01,

Thanks for sharing update with us.

To check issue is related to compatibility please go to open Excel file and hit File> info> under inspect workbook drop down>click check compatibility and see whether there have any error message in dialog box.

Meanwhile, could you please help us to narrow down your issue is related to specific macro in this problematic workbook, could you please try to create new Excel 97-2003 .xls format workbook and insert other macro and see you can run in Excel of Office 365 pro plus on windows.  If you can successfully run other macro in Office 365 Excel workbook, we will help you to move your thread to programming category to narrow down your issue.

Best Regards,

Waqas Muhammad

Answer 2

Hi ntnguyen01,

Thanks for sharing updates with us.

Try changing the name of the file and reopen. Sometimes when you have files with

Regarding to you mention, “Maybe there is setting in my office that prevent this macro from running” to check setting please go to open Excel workbook> file>option>Trust center>Macro setting> click Enable all macros>ok.

Meanwhile, could you please confirm your colleague can run micro Excel file in Office 365 pro plus well as expected?

Best Regards,

Waqas Muhammad

Answer 3

Hi ntnguyen01,

Any updates? Please let us know if you need further help and we are glad to help you here. 

Best Regards,

Waqas Muhammad

Answer 4

Hi Waqas Muhammad,

Thanks for your response. I did enable all macro but it doesn't work. My colleagues are also using office 365 pro plus and facing the same issue.

I still cannot run the macro.

Best regards,

Ngoc Nguyen