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?
Bookmarks