Please be advised that your Google Sheet has to be "Excel-conform" in order to guarantee full functionality.
You can download your Google Sheet as a .xlsx file and take a look if everything is ok in Excel. If yes, the Open as App Wizard should be able to handle the data. If no, you have to fix the problem in Excel and use the same solution (or formulas) in your Google Sheet if possible.
Here is a list of incompatible formulas between Google Sheets and Excel:
- ADD
- ARRAYFORMULA
- CONCAT
- CONTINUE
- COUNTUNIQUE
- DETECTLANGUAGE
- DIVIDE
- EQ
- FILTER
- GOOGLEFINANCE
- GOOGLETOURNAMENT
- GOOGLETRANSLATE
- GT
- GTE
- IMAGE
- IMPORTDATA
- IMPORTFEED
- IMPORTHTML
- IMPORTRANGE
- IMPORTXML
- JOIN
- LT
- LTE
- MINUS
- MULTIPLY
- POW
- QUERY
- SORT
- SPARKLINE
- SPLIT
- TO_TEXT
- TO_PERCENT
- TO_DOLLARS
- TO_DATE
- UMINUS
- UNARY_PERCENT
- UNIQUE
- UPLUS
Comments
0 comments
Please sign in to leave a comment.