Windows 10: Excel 2013 - problems readind formulas created with new Excel files

Hello All, I ask your support on this issue: I often open excel files sent by cistomers/suppliers, etc... with formulas. When I open those in my Excel 2013 the formulas are not working, and instead are wrapped by curly brackets {formula} the formula is still there, but I have to go cell by cell, click F2+Enter and the formula automaticcaly delete brackets. But with several tabs, and thousand of references it is impossible to make the file work. Investigating on Google I found the issue could be related to new Excel suite incorporated Dynamyc Arrays, thus Excel 2013 is not reading formulas correctly. Any Idea how to make excel 2013 read, or convert or correct? Thanks a lot

:)

 

mobile excel formula

"Worksheet names—In a cell in a worksheet, Excel Mobile accurately displays names that reference worksheets within the same workbook. It removes names that refer to other workbooks, arrays such as ={1;2;3;4}, array formulas, or intersection ranges
from the name list. When Excel Mobile removes a name from the list, it leaves the name in formulas and functions. This causes those formulas to be resolved as "#NAME?" Tabs that are hidden in the workbook are not hidden in Excel Mobile."

http://www.microsoft.com/windowsmobile/en-us/help/more/excel-mobile.mspx

You may want to investigate SoftMaker's PlanMaker:

SoftMaker: Official Website

Pocket PC Mauritius omnia i900 avnya henriett

 

mobile excel formula

I need help w/ the formula on excel mobile.

im trying to add data from a different workbook to another worksheet/workbook using excel mobile. ive tried this formula ='[workbook1.xls]sheet1'!I8 and ='[workbook1.xls]sheet1'!$I8 but getting error messages.

my phone is a palm treo

thanx in advance

 

Request for a End-of-month formula for Mobile Excel and a complete list of supported formulas for Mobile Excel

Hi,

So I just have a couple of questions. They stem from my discovery that certain formulas are not supported by the Excel mobile app and that heading then will cause your spreadsheet not to be editable on your mobile app. Ab example of this is the end-of-month
formula (eomonth()). So my two question are:

What is an alternative way of implementing the end-of-month formula in my spreadsheet so that it can be editable on my mobile office app?

Where can I find a list of formulas that are stored by the Excel mobile app so that this doesn't happen again?

Thank you in advance,

John Panzo