Getting Max Allowed Cross Ref Error but only 64K cells cross referenced from other sheets

Greetings all,

I have a smartsheet with 16K rows. each row has 4 columns that have data referenced from other sheets. That should be a total of 64000 referenced from other sheets. However, I am still getting the "Some cross-sheet formulas can't be updated because this sheet has more cells referenced from other sheets then the maximum allowed (100000).

I have un-hid all columns to ensure there were not hidden references.

I also have 4 columns that are sending data to other sheets, but that does not seem applicable to the errors dialog since they are not From other sheets.

Does anyone know why I am getting this error?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

How many unique cross sheet references have you built that point to that 64,000 cell sheet, and what are their ranges?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.