What are the limitations when sharing data?

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, including:

• 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

• Charts

Layer currently does not support:

• 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

Check out how we deal with references in formulas: 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