When sharing an entire spreadsheet

The exact same file will be shared without any Excel feature limitations.

When sharing entire sheets or parts of sheets

Layer supports most Excel features, like:

  • Cell values, including all sorts of number formats and stylings.

  • With currently 430 available Excel functions, we support the vast majority*

  • Hiding and grouping of rows & columns

  • Freeze panes

Layer currently does not support:

  • Graphs

  • Pivot tables

  • Filters

  • Protected & locked cells

  • VBScripts

  • Comments

  • Zoom settings

*currently unsupported functions (77)

ACOT, ACOTH, ARABIC, BAHTTEXT, BASE, BINOM.DIST.RANGE, BINOM.INV, CALL, CHISQ.INV, COMBINA, CONCAT, CONFIDENCE.T, COT, COTH, CSC, CSCH, CUBEKPIMEMBER, CUBEMEMBER, CUBEMEMBERPROPERTY, CUBERANKEDMEMBER, CUBESET, CUBESETCOUNT, CUBEVALUE, DBCS, DECIMAL, ENCODEURL, ERF.PRECISE, ERFC.PRECISE, EUROCONVERT, EXPON.DIST, FILTERXML, FINV, FLOOR.PRECISE, FORECAST.ETS, FORECAST.ETS.SEASONALITY, FORECAST.ETS.STAT, FORMULATEXT, F.TEST, FTEST, GAMMA, GAMMALN.PRECISE, GAUSS, GETPIVOTDATA, IMCOSH, IMCOT, IMCSC, IMCSCH, IMSEC, IMSECH, IMSINH, IMTAN, INFO, ISFORMULA, ISO.CEILING, JIS, LOGNORM.INV, MUNIT, PERMUTATIONA, PHI, PHONETIC, RANDARRAY, REGISTER.ID, RRI, RTD, SEC, SECH, SEQUENCE, SHEET, SHEETS, SKEW.P, SORTBY, SQRT, T.DIST, T.INV, UNIQUE, WEBSERVICE, XLOOKUP, XMATCH, XOR


See how we deal with references in formulas here: Handling references


Do you have a question about the limitations of sharing data?

Chat with us now (click on the blue chat icon on the bottom right corner) or write us an email to support@golayer.io

Did this answer your question?