Excel with VBA not opening on an iPad or iPhone

Greetings,

Thank you in advance for any replies.

I'm in charge of writing and maintaining a bunch of macro enabled Excel files for the managers of our various units. The macros simply open other Excel files, read and extract data from them, and create graphs and tables and such. The macros save the managers lots of time, as otherwise they would have to do it all by hand each month. They then later send these same files directly to the President, for him to review.

He (the President) recently told me that one of the Excel files sent to him won't open on his iPad nor on his iPhone. It only opens up on his PC. All of the others open just fine with his iPad and iPhone. I don't have an iPhone or an iPad so I can't test this. Does anyone know the likely cause?

I suspected the eventual answer would have something to do with the macros. So I saved that file as a regular Excel (xlsx) file, minus all of the macros, and sent it back to him. He says he could open that file...but not access the tabs, for some reason.

I realize this is somewhat of a general question, but can anyone tell me the possible problems with macro-enabled Excel files when accessed with an iPad and an iPhone? Are there certain statements that cause those devices to not open the file? Is it security related and can he turn that off that security for these managers, since he knows these files are okay?

Macros certainly won't run on on iOS. I haven't tried an xlsm, but I can't open an xlsb at all on ios (with the default viewer anyway)

Thanks for responding.

Note that he doesn't need or even want the macros to run. He's just examining the data in the file at this point. But yet he can't open one of the files at all, like he can with all of the others. They are all similar, so I'm at a loss as to why this one file is giving him problems.

When I saved that file as an xlsx file, as a test, it no longer contained any macros at all. He could now open it... yet he couldn't access the worksheet tabs.