MS Excel file when opened on my iPhone ?

[RustyNail]

Hello,

I have created an excel file on Excel on a Windows 7
PC and then emailed it to my iPhone.

Much to my surprise, when I clicked on the file on my
iPhone, the excel file opened.

However, I have some VBA running under the excel
File... Stuff like double click events on certain cells,
Cells which have drop down menus etc...BUT these
Things don't work on the iPhone.

For example when I click on a cell that has a drop down
Menu, the drop down menu doesn't show ???

Is there a way to make my excel file work on my
iPhone exactly the way it works on my windows desktop?

Thanks for all help!
RN

[teylyn]

Hello,

It's not quite clear if the Excel file you emailed to your phone is opening in a generic preview that the iPhone provides natively, or if the file actually opens in Excel for iPhone, which is an application you can download in the Apple Store.

In the generic preview, with no Excel installed on the phone, you can just see the Excel grid. You can't make any changes. Macros will not run and data validation dropdowns don't work.

With Excel for iPhone there are a few more things you can possibly do but they depend on your Excel license.

- if you don't have a Microsoft account, you can view the workbook but not edit it.
- if you do have a Microsoft account and sign in with your Microsoft account and password, you can edit existing workbooks on your phone and create new workbooks. They can be stored in the OneDrive that comes with your account, or stored on the phone.
- if you have an Office 365 license you can use few additional features on the phone, like styling stuff.

In all cases, Excel mobile is intended for light editing, not for fully fledged workbook development. If you can edit a workbook, data validation dropdowns will work. VBA Macros are not supported on Excel for iPhone and will not run.

cheers, teylyn

[RustyNail]

Hello,

It's not quite clear if the Excel file you emailed to your phone is opening in a generic preview that the iPhone provides natively, or if the file actually opens in Excel for iPhone, which is an application you can download in the Apple Store.

In the generic preview, with no Excel installed on the phone, you can just see the Excel grid. You can't make any changes. Macros will not run and data validation dropdowns don't work.

With Excel for iPhone there are a few more things you can possibly do but they depend on your Excel license.

- if you don't have a Microsoft account, you can view the workbook but not edit it.
- if you do have a Microsoft account and sign in with your Microsoft account and password, you can edit existing workbooks on your phone and create new workbooks. They can be stored in the OneDrive that comes with your account, or stored on the phone.
- if you have an Office 365 license you can use few additional features on the phone, like styling stuff.

In all cases, Excel mobile is intended for light editing, not for fully fledged workbook development. If you can edit a workbook, data validation dropdowns will work. VBA Macros are not supported on Excel for iPhone and will not run.

cheers, teylyn

Ok thanks teylyn

Yeah I have macros and my sheet is protected but with certain cells
that are unprotected and on top of this I have modified the ribbon
With custom ui editor.

Bofff I guess I'm asking for too much LOL

Thanks